Searching in source-code in Designer-repository

By | August 14th, 2009|Categories: Database|Tags: , , |

Especially for those who loves Designer, or who are forced to work with it.. 🙁 ,  2 scripts to search in de source-code of Designer (version

Script 1 can be used for searching text-strings in the source of pl/sql in Designer.
Script 2 can be used to search for the use of column-names in modules.

Run this as the owner of the repository.

With thanks to Timo Schijf,  developer.

Script1 : Searching in  pl-sql code

set feedback off
set pages 50000
set lines 300
set trimspool on
set verify off

break on modulename skip 1

select name “Workareas:”
from sdd_workareas

accept workarea_name default ‘GLOBAL SHARED WORKAREA’ char prompt ‘Name of Workarea [Default: GLOBAL SHARED WORKAREA] : ‘

accept searchstring char prompt ‘Text-string : ‘

jr_context.set_workarea (’&&workarea_name’);

select distinct name “Applications in this workarea:”
from ci_application_systems