Friday, February 23, 2018

How to see view script from SQL Prompt?


 SQL> set long 5000 

 SQL> select text from user_views 
         where view_name='VW_INBOX_PO_GENERATED' ;
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...

  • (no title)
    DBCA Fails To Create Oracle 19c Database On AIX [DBT-05509] (Doc ID 2663388.1 ) In this Document ...
  • (no title)
      How to set FILESYSTEMIO_OPTIONS for use with RSA Identity Governance and Lifecycle on a remote Oracle database where Automatic Storage Man...
  • (no title)
    Oracle auditing setup & configuration The Oracle audit command is used to to create specific audit trails for Oracle tables.  to ena...