How to find source code in oracle? -
what difference between dbms_metdata.get_ddl() , user_source table? both can used find source code database, think. of them better other one?
dbms_metadata.get_ddl reads internal tables source$ , adds 'create or replace' part of ddl statement, , formats nicely read , execute.
user_source holds text of source, without formatting or additions allow execution. use view if want search text within code, example. depends how , want find.
Comments
Post a Comment