Practice for create a table tablename=job
Jump to navigation
Jump to 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));