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 vote271 views1 answer
Oracle sql log to console
SQL
0 vote305 views1 answer
Dual in db2
SQL
2 votes294 views1 answer
How to select from mssql
SQL
1 vote264 views1 answer
PL SQL MODIFY COLUMN NME
SQL
4 votes257 views4 answers
Update select mysql
SQL
0 vote271 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote262 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
123 votes436 views5 answers
Sql where contains
SQL
-1 vote285 views1 answer
Auto increment psql not primary key
SQL
0 vote260 views1 answer
Rabbitmq ui not working
SQL