wEbmAstEr powered by AJK Pvt Ltd

--> Create the table STORE, with the fields as given CODE VARCHAR2(15), NAME VARCHAR2(15), QTY NUMBER, PRICE NUMBER Create procedures to perform the following actions into the table STORE. CREATE TABLE store( code VARCHAR2(15), name VARCHAR2(15), qty NUMBER, price NUMBER, PRIMARY KEY(code) ); INSERT record using procedure CREATE OR REPLACE PROCEDURE insertrow(code1 IN VARCHAR2,name1 IN VARCHAR2,qty1 NUMBER,price1 NUMBER) IS BEGIN INSERT INTO store VALUES(code1,name1,qty1,price1); DBMS_OUTPUT.PUT_LINE('One row inserted'); END; / SET SERVEROUTPUT ON DECLARE code VARCHAR2(15); name VARCHAR2(15); qty NUMBER; price NUMBER; BEGIN code:=&enter_the_code; name:=&enter_the_name; qty:=&enter_the_quantity; price:=&enter_the_price; insertrow(code,name,qty,price); END; DELETE record CREATE OR REPLACE PROCEDURE deleterow(code1 IN VARCHAR2) IS BEGIN DELETE FROM store WHERE code LIKE code1; DBMS_OUTPUT.PUT_LINE('One row deleted'); END; / SET SERVEROUTPUT...

--> Write a procedure to find whether a given number is odd or even. CREATE OR REPLACE PROCEDURE oddoreven(num IN NUMBER) IS BEGIN IF(num != 0) THEN IF MOD(num,2) = 0 THEN       DBMS_OUTPUT.PUT_LINE(num ||' IS EVEN'); ELSE       DBMS_OUTPUT.PUT_LINE(num ||' IS ODD'); END IF; ELSE       DBMS_OUTPUT.PUT_LINE('ZERO IS NEITHER PRIME NOR ODD'); END IF; END; / SET SERVEROUTPUT ON DECLARE res NUMBER; num NUMBER; BEGIN num:=&enter_the_number_to_be_checked oddoreven(num); END; --> Develop Procedures to Perform Banking Operations. Create a table bank with attributes accno, name ,balance and insert appropriate values. Create procedures Withdrawal and Deposit respective operations with respect to the table and execute them . CREATE TABLE bank( accno NUMBER, name VARCHAR2(60), balance NUMBER(9,2), PRIMARY KEY(accno) ); INSERT INTO BANK (ACCNO, NAME, BALANCE) VALUES ('20175020', 'classic 350', '75000') IN...

CREATE THE FOLLOWING TABLES AND INSERT THE VALUES client_master product_master salesman_master sales_order sales_order_details CREATE TABLE client_master( client_no VARCHAR2(10), name VARCHAR2(50), city VARCHAR2(40), pincode NUMBER(6), state VARCHAR2(40), bal_due NUMBER(9,2), PRIMARY KEY(client_no) ); INSERT INTO client_master VALUES ('C00001','Anup Dalal','Mumbai',400054,'Maharashtra',15000); INSERT INTO client_master  VALUES ('C00002','Vandana Srivastava','Chennai',600018,'Tamil Nadu',0); INSERT INTO client_master  VALUES ('C00003','Kaustubh Khare','Mumbai',400056,'Maharashtra',5000); INSERT INTO client_master  VALUES ('C00004','Ashok Agarwal','Mumbai',400057,'Maharashtra',0); INSERT INTO client_master  VALUES ('C00005','Vivek Misra','Delhi...

Create the following tables employee department project works_in CREATE TABLE employee( ssn NUMBER, ename VARCHAR2(40) NOT NULL, desig VARCHAR2(20), dno NUMBER, doj DATE, salary NUMBER, PRIMARY KEY (ssn) ); CREATE TABLE department( dnumber NUMBER, dname VARCHAR2(20), loc VARCHAR2(40), mgrssn NUMBER REFERENCES employee(ssn), PRIMARY KEY(dnumber) ); ALTER TABLE employee ADD FOREIGN KEY (dno) REFERENCES department(dnumber); CREATE TABLE projetc( pnumber NUMBER, pname VARCHAR2(20), dnum NUMBER REFERENCES department(dnumber), PRIMARY KEY(pnumber) ); CREATE TABLE works_in( essn NUMBER REFERENCES employee (ssn), pno NUMBER REFERENCES project(pnumber), hrs NUMBER, PRIMARY KEY(essn,pno) ); INSERT INTO department (dnumber,dname,loc)  VALUES (1,'Admin','Banglore'); INSERT INTO department (dnumber,dname,loc)  VALUES (2,'RMG','Kochi'); INSERT INTO department (dnumber,dname,loc)  VAL...

SET-I   Create the table student with fields  SID Sname, DOB, Physic, Chems, Maths. CREATE TABLE student( sid NUMBER(3), sname VARCHAR2(60), dob DATE, physics NUMBER(5,2), chems NUMBER(5,2), maths NUMBER(5,2), PRIMARY KEY (sid) ); Add few rows into the table INSERT INTO student VALUES(301,'Abraham Mathew','23-June-1996',75,87,37); INSERT INTO student VALUES(302,'Adharsh Sunny','29-April-1995',78,82,90); INSERT INTO student VALUES(303,'Anson Mathew','27-February-1997',65,31,88); INSERT INTO student VALUES(304,'Arun Joji','17-March-1994',38,55,60); INSERT INTO student VALUES(305,'Christin Chacko','03-May-1994',82,88,97); INSERT INTO student VALUES(306,'Dimal Mathew','21-December-1994',91,96,99); INSERT INTO student VALUES(307,'Jeethu Mathew','19-April-1993',77,83,40); INSERT INTO student VALUES(308,...