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...