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 vote170 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
3 votes280 views1 answer
Ssh check mysql version
SQL
10 votes168 views4 answers
Primary key sql
SQL
0 vote158 views1 answer
Sql string length postgresql
SQL
0 vote163 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote167 views1 answer
Change date format in oracle query
SQL
16 votes164 views4 answers
Sort by sql
SQL
0 vote163 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
6 votes267 views3 answers
Psql show columns of table
SQL
0 vote214 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL