Skip to Main Content

Database Software

views to be included in ~source metadata view (~=dba_ (or) user_ (or) all_ )

ManikJun 24 2016

This may sound very basic.. but I think it would be good to include views also in dba_source  (or user_source/all_source)

Lets say I search for a text called "HELLOWORLD" in the code base, we use :

--------------------------------

DROP TABLE tbl_vw_dba_views;


CREATE TABLE tbl_vw_dba_views
AS
   SELECT owner, view_name, TO_LOB (text) text FROM dba_views;  ---- this is again because of the limitation of text column being LONG so converting this into lob.

-----------------------------------
SELECT distinct owner,name,typ
  FROM (SELECT owner, name, TO_CLOB (text) text, TYPE typ FROM dba_source
        UNION ALL
        SELECT owner, view_name, TO_CLOB (text), 'VIEW' FROM tbl_vw_dba_views)
WHERE UPPER (text) LIKE '%HELLOWORLD%';

------------------------------------

Instead, if the  views are also included in the source it would be helpful..

May be a small thing but can help I guess...

Please let me know if this is already implemented somewhere in some other form/approach or am I missing something here?

Thanks!

Cheers,

Manik.

Comments
Post Details
Added on Jun 24 2016
1 comment
323 views