79812574

Date: 2025-11-07 16:35:17
Score: 0.5
Natty:
Report link

Best way with one single query is:

SELECT view_name FROM (
    SELECT view_name,
           case when (DBMS_METADATA.GET_DDL('VIEW', view_name, 'YOUR OWNER')  LIKE '%SEARCH QUERY%') then 'Y' else 'N' end as flg_result
    FROM user_views)
where flg_result = 'Y'
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Marco Di Scala