« mySQL: size of the database | Home | mysql: rownum functionality »

Oracle: source text for the view, package etc

Source text of the package

SELECT text
FROM dba_source
WHERE upper(name) LIKE upper('&which_object')
ORDER BY line ;

Use $ORACLE_HOME/bin/wrap utility to encrypt the package (there is no unwrap)
(Well, actually, there is unwrap - just look in the search machine for the words unwrap10 or rewrap...)

Source text of the views

SET long 5000
col text FOR a80

SELECT text FROM dba_views WHERE view_name = upper('&which_view');
SELECT query FROM DBA_mviews WHERE mview_name = upper('&which_view');
SELECT view_definition FROM v$fixed_view_definition WHERE view_name='&which_view';

Source text of the synonym

SELECT TABLE_OWNER || '.' || TABLE_NAME || decode ( db_link , NULL , '' , '@' || db_link ) SYNONYM_OBJECT
FROM dba_synonyms
WHERE SYNONYM_NAME = upper('&which_synonym');

Source text of the trigger

SELECT
 'create or replace trigger "' || trigger_name || '"'
  || chr(10)|| decode( substr( trigger_type, 1, 1 ), 'A', 'AFTER', 'B', 'BEFORE', 'I', 'INSTEAD OF' ) || chr(10) ||
  triggering_event || chr(10) || 'ON "' || table_owner || '"."' || table_name
  || '"' || chr(10) || decode( instr( trigger_type, 'EACH ROW' ), 0, NULL, 'FOR EACH ROW' ) || chr(10) ,
  trigger_body
FROM dba_triggers
WHERE trigger_name = upper('&which_trigger')  AND owner=upper('&trigger_owner');

Topics: Oracle, reverse, text | Submitter: checkthis

Comments

You must be logged in to post a comment.

Keep on coding