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

What are the types of index in sql?

524


Are sql connections encrypted?

547


How we can update the view?

593


What is fmtonly in sql?

519


What is the use of partition by in sql?

508






What are the advantages of stored procedure?

533


What is the best free sql database?

554


How does postgresql compare to oracle/db2/ms sql server/informix?

547


List and explain the different types of join clauses supported in ansi-standard sql?

804


What type of join is sql join?

520


What are the indexing methods?

564


Are subqueries faster than joins?

562


How do you declare a variable in pl sql?

527


Which join condition can be specified using on clause?

508


What is lookup table in sql?

595