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 vote318 views1 answer
Search In the Data using ObjectName
SQL
0 vote314 views1 answer
Select max salary from each department in sql
SQL
0 vote330 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote326 views1 answer
Python sqlalchemy orm to select null values
SQL
3 votes474 views9 answers
Linq to sql converter online
SQL
0 vote331 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote353 views3 answers
Call to undefined function mysql_connect()
SQL
5 votes365 views2 answers
Functions
SQL
0 vote320 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote314 views1 answer
Object Information
SQL