Create table supplier(suppno varchar2(10) primary key, suppname varchar2(25)) Insert into supplier values(‘S1’,’BRU’); Insert into supplier values(‘S2’,’Al-Rawbi’); Create table product(pno number(5) primary key, pname varchar2(20), rate number(6,2),suppn varchar2(10) references supplier(suppno),qty number(5)); Insert into product values(11,’coffee’,1.2,'S1',1); Insert into product values(12,’coolcoffee’,1.4,'S1',5); Insert into product values(13,’icecream’,2.2,'S1',4); Insert into product values(14,’recor’,1.8,’S2’,3); change ' single quotes because this i typed in word
Can you please write in the comment section the commands for creating the SUPPLIER & PRODUCT table?
Create table supplier(suppno varchar2(10) primary key, suppname varchar2(25))
Insert into supplier values(‘S1’,’BRU’);
Insert into supplier values(‘S2’,’Al-Rawbi’);
Create table product(pno number(5) primary key, pname varchar2(20), rate number(6,2),suppn varchar2(10) references supplier(suppno),qty number(5));
Insert into product values(11,’coffee’,1.2,'S1',1);
Insert into product values(12,’coolcoffee’,1.4,'S1',5);
Insert into product values(13,’icecream’,2.2,'S1',4);
Insert into product values(14,’recor’,1.8,’S2’,3);
change ' single quotes because this i typed in word
How do we add the horizontal scroll inside the TAB page?
Easily understand of your lesson but screen recorder quality is not good
Good Mam
thanks sir