What are the different types of PL/SQL program units that
can be defined and stored in ORACLE database ?

Answer Posted / pratima

CONSUMER GROUP
DIRECTORY
FUNCTION
INDEX
INDEXTYPE
JAVA CLASS
JAVA RESOURCE
LIBRARY
OPERATOR
PACKAGE
PACKAGE BODY
PROCEDURE
SEQUENCE
SYNONYM
TABLE
TRIGGER
TYPE
VIEW

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

868


Write a query to find the names of users that begin with "um" in sql?

703


How to handle bulk data?

1050


what is an extent ? : Sql dba

751


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

812






what is blob? : Sql dba

736


What are system versioned tables?

735


How many joins can you have in sql?

687


When is the explicit cursor used ?

764


What is posting?

777


What is sql character function?

709


How to move files from one directory to another in pl sql?

854


The in operator may be used if you know the exact value you want to return for at least one of the columns.

723


What is use of term?

792


Explain the difference between sql and mysql.

753