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

1 vote311 views3 answers
Mysql connection string
SQL
0 vote303 views1 answer
Synapse sql table set pk
SQL
4 votes374 views1 answer
Oracle table statistics
SQL
0 vote289 views1 answer
Delete insert record in sql server
SQL
0 vote296 views1 answer
Sql server inner join convert collation
SQL
0 vote295 views1 answer
What is mysql_pconnect
SQL
15 votes301 views4 answers
T-sql drop function if exists
SQL
0 vote286 views1 answer
How to remove default in mysql
SQL
1 vote292 views1 answer
Sql select where id not exists in another table
SQL
31 votes300 views1 answer
Postgresql add column with constraint
SQL