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

2 votes163 views1 answer
Oracle trace file
SQL
0 vote152 views1 answer
How get data from database if id not found then search another column
SQL
6 votes192 views2 answers
Install psql mac
SQL
0 vote163 views1 answer
Pgadmin check database
SQL
6 votes149 views2 answers
Foreign key sqlite3 python
SQL
13 votes142 views2 answers
Oracle select into and inner join
SQL
2 votes136 views1 answer
Sql create database
SQL
0 vote139 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote159 views1 answer
Snowflake drop column
SQL
0 vote162 views1 answer
Postgresql port 5432 not open
SQL