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

20 votes227 views4 answers
Reset auto increment in MySQL
SQL
2 votes241 views1 answer
Postgresql transaction
SQL
0 vote181 views1 answer
Oracle last user logon
SQL
2 votes275 views1 answer
Oracle find constraints referencing a table
SQL
0 vote237 views1 answer
Mysql url data type
SQL
3 votes237 views2 answers
Mysql create timestamp column
SQL
0 vote245 views1 answer
Sql output select
SQL
2 votes237 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote254 views1 answer
C# get sql min date
SQL
0 vote221 views1 answer
Myswql show full processlist
SQL