Practice for create a table tablename=job

From SQLZOO
Revision as of 15:44, 24 October 2012 by 11ce071 (talk | contribs) (Created page with "create table job("job_id"varchar2(15),"job_title"varchar2(30),"min_sal"number(7,2),"max_sal"number(7,2)); create table employee("emp_no"number(3),"emp_name"varchar2(30),"emp_s...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

create table job("job_id"varchar2(15),"job_title"varchar2(30),"min_sal"number(7,2),"max_sal"number(7,2)); create table employee("emp_no"number(3),"emp_name"varchar2(30),"emp_sal"number(8,2),"emp_comm"number(6,1),"dept_no"number(3)); create table deposit("a_no"varchar2(5),"cname"varchar2(15),"bname"varchar2(10),"amount"number(7,2),"a_date"date); create table borrow("loanno"varchar2(5),"cname"varchar2(15),"bname"varchar2(10),"amount"varchar2(7));

File:11ce071