Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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 ?    3 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

Are views faster than queries?

0 Answers  


What normalization means?

0 Answers  


State few characteristics of pl/sql?

0 Answers  


table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,


If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,






Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  


How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  


What is trigger explain with example?

0 Answers  


What do you mean by field in sql?

0 Answers  


My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,


What does stand for in sql?

0 Answers  


why we use nocopy?

2 Answers   Polaris,






Categories