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

11 votes141 views2 answers
MySQL DISTINCT
SQL
0 vote140 views1 answer
Mysql command prompt date insert format
SQL
-1 vote143 views1 answer
Count occurrences sql
SQL
0 vote89 views1 answer
Ms sql print more than 1 variable
SQL
2 votes136 views1 answer
Oracle drop table free up space
SQL
0 vote229 views3 answers
Insert or ignore postgres
SQL
6 votes153 views2 answers
Return columns from table sql
SQL
1 vote137 views1 answer
SQL date part only of datetime
SQL
0 vote142 views1 answer
Postgres list tables and row counts
SQL
0 vote178 views1 answer
Call function sql oracle with output put line
SQL