• Programming Languages

test

sqlite Live Demo Short URL - http://tpcg.io/bgXEiz

plsql

sqlite Live Demo Short URL - http://tpcg.io/78dEn7

Execute SQL Online

sqlite Live Demo Short URL - http://tpcg.io/15jqpA

CREATE TABLE Classe ( Cd_Classe NUMBER(8), Nr_AnoLetivo NUMBER(4), Nr_Serie NUMBER(2), Sg_Turma VARCHAR2(2), Cd_Escola NUMBER(6), Cd_Grau NUMBER(2), Cd_Periodo NUMBER(2), CONSTRAINT Classe_Cd_Classe_pk PRIMARY KEY (Cd_Classe) );

sqlite Live Demo Short URL - http://tpcg.io/8CzBeU

6. Employee Database (SQL CONSTRAINTS)

sqlite Live Demo Short URL - http://tpcg.io/ehpKNN

db2 select 'db2 rebind package ' concat ltrim(rtrim(pkgname)) from syscat.packages p,syscat.routines r where substr(implementation,1,length(pkgname))=pkgname and p.pkgschema = 'LN' and p.valid = 'N'  > c:\reb.db2

sqlite Live Demo Short URL - http://tpcg.io/5UQ3zo

SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hDbc ) SQLConnect( hDbc, "CERTDB", SQL_NTS, "user1", SQL_NTS, "passwd", SQL_NTS ) SQLAllocHandle( SQL_HANDLE_STMT, hDbc, &hStmt ) SQLExecDirect( hStmt, "SET CURREN

sqlite Live Demo Short URL - http://tpcg.io/7ZBJCs

4.2. Employee Database (SELECT ROW)

sqlite Live Demo Short URL - http://tpcg.io/74oTqT

4.1. Employee Database (SELECT ROW)

sqlite Live Demo Short URL - http://tpcg.io/BqkWeP

2. Employee Database (ALTER TABLES)

sqlite Live Demo Short URL - http://tpcg.io/cSwCRi
Previous 1 ... 72 73 74 75 76 ... 111 Next
Advertisements