wEbmAstEr powered by AJK Pvt Ltd

Create the following tables and execute the queries given below sailor boat reserve CREATE TABLE sailors( sid NUMBER(3), sname varchar2(100), rating NUMBER(2), age NUMBER(3), PRIMARY KEY(sid) ); INSERT INTO sailors VALUES(22,'Dustin',7,45); INSERT INTO sailors VALUES(29,'Brutas',1,33); INSERT INTO sailors VALUES(31,'Luber',8,55); INSERT INTO sailors VALUES(32,'Andy',8,25); INSERT INTO sailors VALUES(58,'Rusty',10,35); INSERT INTO sailors VALUES(64,'Horatio',9,35); INSERT INTO sailors VALUES(71,'Zorba',10,16); INSERT INTO sailors VALUES(74,'Horatio',9,35); INSERT INTO sailors VALUES(85,'Art',3,25.5); INSERT INTO sailors VALUES(95,'Bob',3,63.5); CREATE TABLE boats( bid NUMBER(3), bname VARCHAR2(50), color VARCHAR2(25), PRIMARY KEY(bid) ); INSERT INTO boats VALUES(101,'Interlake','Blue'); INSERT INTO boats VALUES(102,'Inter...

Create the tables given below and execute the queries: Customer(Cust id : integer, cust_name: string) Item(item_id: integer, item_name: string, price: integer) Sale(bill_no: integer, bill_date: date, cust_id: integer, item_id: integer, qty_sold: integer)   CREATE TABLE customer( cust_id INTEGER NOT NULL, cust_name VARCHAR2(100) NOT NULL, PRIMARY KEY(cust_id) ); INSERT INTO customer VALUES(501,'ARUN JOJI'); INSERT INTO customer VALUES(502,'CHRISTIAN CHACKO'); INSERT INTO customer VALUES(503,'DENNY JOSE'); INSERT INTO customer VALUES(504,'FAZIL HABEEB'); INSERT INTO customer VALUES(505,'JITHU SEBASTIAN'); INSERT INTO customer VALUES(506,'KISHORE THOMAS'); INSERT INTO customer VALUES(507,'LEBIN KURIAKOSE'); INSERT INTO customer VALUES(508,'MANUAL CHERIAN'); INSERT INTO customer VALUES(509,'NIRMAL THOMAS'); INSERT INTO customer VALUES(510,'JEETHU MATHEW'); CREATE TA...

1.  Create the table STUDENT_INFO with Columns: Sid, Stud_name & stude_score . create table STUDENT_INFO( sid NUMBER(3) NOT NULL, stud_name VARCHAR2(100) NOT NULL, stud_score NUMBER(3) DEFAULT 20, primary key(sid) ); -->   Insert  values into STUDENT_INFO with the following constraints: Stud name NOT NULL and stude_score DEFAULT value of 20 . INSERT INTO STUDENT_INFO (sid,stud_name) VALUES(9,'Adharsh Sunny'); INSERT INTO STUDENT_INFO VALUES(2'Dimal Mathew',200); INSERT INTO STUDENT_INFO VALUES(3,'Arun Joji',170); INSERT INTO STUDENT_INFO VALUES(4,'MAnuel Cherian',180); INSERT INTO STUDENT_INFO VALUES(5,'Christin Chacko',90); INSERT INTO STUDENT_INFO VALUES(6,'Jithu Sebastian',110); INSERT INTO STUDENT_INFO VALUES(7,'Fazil Habeeb',160); INSERT INTO STUDENT_INFO VALUES(8,'Visakh harikumar',101); -->   Update stude_score by adding a value of 5 to stude_score in the table STUDENT_...