Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Location
    India
    Posts
    96

    Unanswered: Extract the package from database

    How to extract the package into a file with line number or into a table with line number?

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Query USER_SOURCE (ALL_SOURCE / DBA_SOURCE for other schemas):
    Code:
    SQL> desc user_source
     Name                                      Null?    Type
     ----------------------------------------- -------- ----------------------------
     NAME                                               VARCHAR2(30)
     TYPE                                               VARCHAR2(12 CHAR)
     LINE                                               NUMBER
     TEXT                                               VARCHAR2(4000)

  3. #3
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    is there any systematic way to find all the KEYWORDS inside the package are in UPPER case only?

    is there any table available in ORACLE to get all the keywords?

  4. #4
    Join Date
    Mar 2007
    Posts
    623
    Quote Originally Posted by karthi_syb
    is there any systematic way to find all the KEYWORDS inside the package are in UPPER case only?
    Maybe some code formatters may be able to do this. But beware that keywords may be also used as identifiers (not recommended by Oracle, however code containing it may work correctly). As identifiers are case insensitive in Oracle, I find it senseless.
    Quote Originally Posted by karthi_syb
    is there any table available in ORACLE to get all the keywords?
    Code:
    SQL> desc v$reserved_words
     Name                                      Null?    Type
     ----------------------------------------- -------- ----------------------------
     KEYWORD                                            VARCHAR2(30)
     LENGTH                                             NUMBER
     RESERVED                                           VARCHAR2(1 CHAR)
     RES_TYPE                                           VARCHAR2(1 CHAR)
     RES_ATTR                                           VARCHAR2(1 CHAR)
     RES_SEMI                                           VARCHAR2(1 CHAR)
     DUPLICATE                                          VARCHAR2(1 CHAR)
    Keywords are listed in SQL Reference (for SQL) and PL/SQL User's Guide and Reference (for PL/SQL).
    Oracle dictionary objects are described in Database Reference.
    All these books are part of Oracle documentation, available e.g. online on http://tahiti.oracle.com/. Please, read it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •