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

Code to be used to view the source of a trigger.



SET PAGES 0
SET HEADING OFF
SET VERIFY OFF
SET LINES 255
SET FEEDBACK OFF
SET ARRAYSIZE 1
SET LONG 100000
SET TRIMSPOOL ON

COLUMN DESCRIPTION FORMAT A132
COLUMN TRIGGER_BODY FORMAT A132
COLUMN WHEN_CLAUSE FORMAT A132

DEFINE P_TRIG = '&1'

SET ECHO OFF
SET TERMOUT OFF

SELECT 'CREATE OR REPLACE TRIGGER 'DESCRIPTION
, DECODE(WHEN_CLAUSE,NULL,NULL,'WHEN ('WHEN_CLAUSE')')
, TRIGGER_BODY
FROM USER_TRIGGERS
WHERE TRIGGER_NAME = UPPER('&P_TRIG');

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