PL/SQL Packages DBMS_DESCRIBE

Get information about a PL/SQL object.

Contains only one procedure: DESCRIBE_PROCEDURE

The package declares two PL/SQL table types which are used 
to hold data returned by its OUT parameters.

TYPE VARCHAR2_TABLE IS TABLE OF VARCHAR2(30)
    INDEX BY BINARY_INTEGER;

TYPE NUMBER_TABLE IS TABLE OF NUMBER
    INDEX BY BINARY_INTEGER;


For full documentation of the packaged procedure above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

"I have a lot of street smarts because of the neighbourhood I grew up in" - Jennifer Lopez

Related Commands:

DESC

Related Views

                      ALL_ARGUMENTS        USER_ARGUMENTS
 DBA_OBJECTS          ALL_OBJECTS          USER_OBJECTS         SYS_OBJECTS 
 DBA_SOURCE           ALL_SOURCE           USER_SOURCE 



© Copyright SS64.com 1999-2013
Some rights reserved