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 vote113 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote126 views1 answer
Get a list of tables and the primary key
SQL
8 votes131 views2 answers
Grant all privileges database postgres to user
SQL
0 vote130 views3 answers
How to assign custom id in mysql
SQL
0 vote114 views1 answer
Oracle shrink table
SQL
-1 vote136 views4 answers
Full outer join in sql
SQL
1 vote108 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
5 votes129 views3 answers
Sql server utc to local
SQL
16 votes120 views3 answers
Tsql rename column name
SQL
2 votes117 views1 answer
Removing view
SQL