What are the different types of PL/SQL program units that
can be defined and stored in ORACLE database ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Can we commit in trigger?
what is the different between unique+not null & primary key,
How do you respond to dementia behavior?
Mention what does plv msg allows you to do?
What is Raise_application_error ?
Why do we use %rowtype & %type in plsql?
How we can update the view?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
how to return query output in html format? : Sql dba
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
explain primary keys and auto increment fields in mysql : sql dba
What is %rowtype in pl sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)