Tuesday, 14 July 2015

how to compile the objects ? (or) how to make the objects invalid to valid ?

alter <object_type>   <owner.object_name>  compile:

ex:    alter  view  j_view  compile;

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...