1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Example of Native Dynamic SQLs

VARIABLE tabname varchar2(20)
VARIABLE prod_id number
VARIABLE wh_id number
VARIABLE qoh number



CREATE TABLE ch (t_p_id NUMBER(3), t_wh_id NUMBER(3), t_qoh NUMBER(5));



CREATE PROCEDURE insert_into_table (
table_name VARCHAR2,
p_prod_id NUMBER,
p_wh_id NUMBER,
p_quantity NUMBER
)
IS
v_stmt_str VARCHAR2 (200);
BEGIN
v_stmt_str :=
'INSERT INTO ' || table_name || ' values (:prod_id, :wh_id, :qoh)';

EXECUTE IMMEDIATE v_stmt_str
USING p_prod_id, p_wh_id, p_quantity;
END insert_into_table;
/


EXECUTE insert_into_table('ch', 3,4,5);


SELECT *
FROM ch;

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy