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 vote340 views1 answer
Sql select column names starting with
SQL
2 votes368 views1 answer
How to find constraints on a table in oracle
SQL
0 vote361 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote365 views1 answer
Mysql enter ubuntu
SQL
1 vote353 views1 answer
How refresh navicat tables to see new tables
SQL
4 votes423 views2 answers
Postgresql float data type
SQL
12 votes394 views2 answers
Insert multiple rows from another table sql
SQL
1 vote354 views1 answer
Add current timestamp in mysql
SQL
0 vote379 views1 answer
Suhaib
SQL
17 votes431 views1 answer
Selecting name that contain certain word in sql
SQL