Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / guest

Procedure
Functions
Triggers
Views

Is This Answer Correct ?    4 Yes 0 No

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

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

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between local variables and global variables?

0 Answers  

What is before trigger?

0 Answers  

What are triggers and its uses?

0 Answers  

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,




Why partition by is used in sql?

0 Answers  

How do I run a sql query in pgadmin 4?

0 Answers  

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

what is the difference between implicit conversions and explicit conversions?

2 Answers  

How do you break a loop in pl sql?

0 Answers  

What is data type in database?

0 Answers  

Which is faster view or stored procedure?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories