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

To trace Source Of All Procedures, Functions, Packages & Package Bodies in Oracle

SET trimspool on
SET pagesize 50000
SET feedback off
SET heading off
SET long 100000
SET linesize 150

SPOOL On
SPOOL ProFunPac.sql

SELECT DECODE (line,
1, CHR (10)
|| CHR (10)
|| '-- '
|| TYPE
|| ' : '
|| NAME
|| CHR (10)
|| 'Create Or Replace '
|| text,
text
)
FROM user_source
WHERE TYPE IN ('PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY')
ORDER BY NAME, TYPE, line
/
SPOOL Off
SET linesize 80
SET heading on
SET feedback 6
SET pagesize 32
SET trimspool off
SET long 80

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