Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE TABLE CursoSequencia (
  2. cod_curso NUMBER(3),
  3. nome_curso VARCHAR2(30) NOT NULL,
  4. carga_hor NUMBER(3),
  5. CONSTRAINT cursoSquencia_cod_pk PRIMARY KEY(cod_curso)
  6. );
  7.  
  8. CREATE SEQUENCE cod_curso INCREMENT BY 1
  9. START WITH 1001;
  10.  
  11. INSERT INTO CursoSequencia VALUES(cod_curso.nextval, ‘AdministracaoOracle’,3);
  12.  
  13. INSERT INTO CursoSequencia VALUES(cod_curso.nextval, ‘AdministracaoSQLServer’,3);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement