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 using DBMS_SQL

--variable rows_deleted number
--execute proc1('emp', :rows_deleted);


CREATE OR REPLACE PROCEDURE proc1 (
p_tab_name IN VARCHAR2,
p_rows_del OUT NUMBER
)
IS
cursor_name INTEGER;
BEGIN
cursor_name := DBMS_SQL.open_cursor;
DBMS_SQL.parse (cursor_name, 'DELETE FROM ' || p_tab_name,
DBMS_SQL.native);
p_rows_del := DBMS_SQL.EXECUTE (cursor_name);
DBMS_SQL.close_cursor (cursor_name);
END;
/

--print rows_deleted
ROLLBACK

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