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 vote335 views1 answer
Possgress drop if exists view
SQL
0 vote319 views1 answer
Sql server separar numeros por comas miles
SQL
2 votes313 views3 answers
Oracle show column of table
SQL
0 vote396 views1 answer
Stop and start mysql
SQL
11 votes342 views3 answers
Python sqlite3 create table if not exists
SQL
3 votes329 views1 answer
Postgres kill running query
SQL
4 votes302 views2 answers
Sql vs mysql
SQL
0 vote295 views1 answer
Lister les index d'une table oracle
SQL
2 votes337 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote325 views2 answers
Oracle select
SQL