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 vote172 views1 answer
How to subquey to do not load in live database in
SQL
1 vote139 views1 answer
Declare table variable
SQL
0 vote166 views1 answer
TSQL convert csv to table
SQL
1 vote110 views1 answer
Psql kill pid
SQL
0 vote149 views1 answer
Mysql DDL
SQL
0 vote151 views1 answer
Implicit inner join table alias with id values
SQL
27 votes151 views4 answers
Get all tables with column name sql
SQL
0 vote138 views1 answer
Kotlin sqlite delete row
SQL
0 vote138 views2 answers
Mysql password error create datbase
SQL
0 vote136 views1 answer
Sqlite to csv statement
SQL