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 vote142 views1 answer
Manage Database in MySQL
SQL
0 vote144 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
3 votes131 views1 answer
Créer une table sql
SQL
1 vote128 views2 answers
Grab part of a string sql
SQL
17 votes140 views3 answers
Postgresql version command
SQL
5 votes142 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote123 views1 answer
Where case insensitive like mysql
SQL
1 vote149 views1 answer
How to run parallel queries in sql server with entity framework
SQL
15 votes137 views6 answers
Psql
SQL
1 vote146 views1 answer
Add current timestamp in mysql
SQL