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

4 votes209 views2 answers
Tables in sql
SQL
103 votes355 views1 answer
Like sql
SQL
0 vote217 views1 answer
Less than and between in sql query
SQL
2 votes171 views1 answer
Sql float to int
SQL
4 votes221 views2 answers
Show all database inside postgresql
SQL
0 vote218 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote229 views1 answer
Changing name of column and datatype in sql
SQL
0 vote226 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
2 votes223 views1 answer
Postgresql transaction
SQL
0 vote219 views1 answer
Best way to bind parameters to SqlCommand C#
SQL