Category Archives: oracle

Print out Oracle Pl/SQL text from SQL*Plus

SET pagesize 5000 SET linesize 1000 SELECT text FROM ALL_SOURCE WHERE name=’MY_PROC’ AND owner=’MY_APP’;

Posted in oracle | Tagged , , | Leave a comment