4 Replies Latest reply: Nov 18, 2012 3:10 PM by 974863 RSS

    Is PL/Scope all about all_identifiers?

    974863
      I have just read Steven's article about PL/Scope ( http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o50plsql-165471.html ) he explains PL/Scope. I could understand the main things about it. However, I have got a question. Is it all about all_identifiers data dictionary view? Because he has just used it.


      In addition do you recommend me any source about this topic?

      Thanks a lot for your help from now.
        • 1. Re: Is PL/Scope all about all_identifiers?
          sb92075
          971860 wrote:
          I have just read Steven's article about PL/Scope ( http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o50plsql-165471.html ) he explains PL/Scope. I could understand the main things about it. However, I have got a question. Is it all about all_identifiers data dictionary view? Because he has just used it.


          In addition do you recommend me any source about this topic?

          Thanks a lot for your help from now.
          SQL> select type, count(*) from all_identifiers group by type order by 1;
          
          TYPE                 COUNT(*)
          ------------------ ----------
          ASSOCIATIVE ARRAY           1
          BFILE DATATYPE              4
          BLOB DATATYPE              11
          BOOLEAN DATATYPE          347
          CHARACTER DATATYPE        532
          CLOB DATATYPE             126
          CONSTANT                   12
          DATE DATATYPE             136
          EXCEPTION                  46
          FORMAL IN                1742
          FORMAL OUT                  6
          
          TYPE                 COUNT(*)
          ------------------ ----------
          FUNCTION                 1028
          INDEX TABLE                 3
          INTERVAL DATATYPE           4
          NESTED TABLE               47
          NUMBER DATATYPE           212
          OBJECT                     67
          OPAQUE                     63
          PACKAGE                    15
          PROCEDURE                  22
          RECORD                      3
          REFCURSOR                   7
          
          TYPE                 COUNT(*)
          ------------------ ----------
          SUBTYPE                   879
          SYNONYM                     2
          TIME DATATYPE               4
          TIMESTAMP DATATYPE          6
          UROWID                     16
          VARIABLE                    5
          VARRAY                      1
          
          29 rows selected.
          does reality above change your conclusion?


          How do I ask a question on the forums?
          SQL and PL/SQL FAQ
          • 2. Re: Is PL/Scope all about all_identifiers?
            974863
            any suggestion?
            • 3. Re: Is PL/Scope all about all_identifiers?
              rp0428
              >
              Is it all about all_identifiers data dictionary view? Because he has just used it.
              >
              That view is where the information is stored. The functionality is used to gather information about identifiers and the view makes that information available to you.
              >
              In addition do you recommend me any source about this topic?
              >
              You should always read the Oracle docs to get information about Oracle functionality.

              See Using PL/Scope in the Oracle® Database Advanced Application Developer's Guide
              http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm

              There is also more information and examples in these two threads
              Re: Finding out all procedures , functions in a tree like structure in sequence
              Re: how to find dependency procedure names within a  package
              • 4. Re: Is PL/Scope all about all_identifiers?
                974863
                rp0428 thanks a million.