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 EXECUTE IMMEDIATE

--create table e as select * from employees

--set serveroutput on

--variable deleted number

CREATE OR REPLACE PROCEDURE procsql (tab_name VARCHAR2, dele OUT NUMBER)
IS
BEGIN
EXECUTE IMMEDIATE ('DELETE FROM ' || tab_name);

dele := SQL%ROWCOUNT;
END;
/

SHOW errors



--ROLLBACK

--execute procsql('e', :deleted);

PRINT DELETED

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