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 vote238 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
10 votes189 views1 answer
Oracle dba_dependencies
SQL
20 votes188 views2 answers
Mysql bigint max value
SQL
4 votes198 views3 answers
Is not null sql
SQL
15 votes185 views2 answers
Open postgress in terminal mac
SQL
8 votes195 views3 answers
SQL column name
SQL
0 vote184 views1 answer
Sqlite referential integrity
SQL
1 vote185 views1 answer
Backup mysql data only
SQL
0 vote180 views1 answer
Wordpress database query change url
SQL
2 votes202 views3 answers
Row number mysql
SQL