Create table employees oracle

create table EMPLOYEES (  
  empno             number,  
  name              varchar2(50) not null,  
  job               varchar2(50),  
  manager           number,  
  hiredate          date,  
  salary            number(7,2),  
  commission        number(7,2),  
  deptno           number,  
  constraint pk_employees primary key (empno),  
  constraint fk_employees_deptno foreign key (deptno) 
      references DEPARTMENTS (deptno)  
);

Source: livesql.oracle.com

Similar codes

0 vote192 views2 answers
Mysql two column combination unique
SQL
1 vote219 views1 answer
Import mysql dump database command line linux
SQL
3 votes158 views4 answers
Show columns from table
SQL
5 votes197 views1 answer
Sql add column after another
SQL
0 vote197 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
1 vote214 views1 answer
How to see all table partition in oracle
SQL
0 vote215 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote252 views1 answer
Create function in microsoft sql server
SQL
5 votes228 views1 answer
Oracle get ddl
SQL
0 vote220 views1 answer
Drop index in sql
SQL