Practice for create a table tablename=job

From SQLZOO
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