The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
SQL
By Guest on 12th March 2019 08:59:02 AM | Syntax: TEXT | Views: 1



New paste | Download | Show/Hide line no. | Copy text to clipboard
  1. create table dept_locations (dnumber number(1) check (dnumber>0 and dnumber<=4),dlocations varchar(20) check (dlocations in ('SINGAPORE','INDIA','QUUENSLAND','LONDON')));
  2.  
  3. create table project (pname varchar2(20) check (pname in ('NETWORKING','BIO INFORMATICS','LINUX')),plocation varchar2(20) check (plocation in ('KOREA','SOUTH AFRICA','INDIA')));
  4.  
  5. create table works_on (esrno number(6) check (esrno>0),pno number(10) check (pno>0),hours number(3,2) check (hours>0));



  • Recent Pastes