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 vote167 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote176 views1 answer
Database schema for mcqs type exam in sql
SQL
2 votes162 views1 answer
Oracle sql concatenate results into string
SQL
1 vote186 views1 answer
Oracle create_program
SQL
1 vote159 views1 answer
Importance of comment in mysql
SQL
0 vote339 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
1 vote187 views1 answer
Change table to innodb mysql
SQL
14 votes177 views4 answers
Sql compiler
SQL
4 votes189 views1 answer
Is there any command to change postgres password
SQL
3 votes181 views1 answer
Oracle revoke
SQL