2011/06/07

Select from data dictionary

I often use this
SQL> SELECT VIEW_NAME FROM ALL_VIEWS
  2  WHERE VIEW_NAME LIKE '%K-E-Y-W-O-R-D%';
to find from what system or user view i can select samething what i need: objects, privilegies, users, APEX pages or processes.

No comments:

Post a Comment