Home

Current Article

Describe the difference between a procedure, function and anonymous pl/sql block.

By admin on Mar 8, 2007 in PL/SQL interview questions

Level: Low
Expected answer : Candidate should mention use of DECLARE statement, a function must
return a value while a procedure doesn?t have to.

1 Comment(s)
By bhagya on Jul 1, 2008 | Reply

what is the difference between anonymous ,procedure,function block?

Tech Portals
Recent Comments
- monika on Management Education - Is it necessary to succeed in business
- rajesh on Performance tuning of SQR?
- Ojaswi on SAP-HR Interview Questions
- Balamurugan G on What is difference between TRUNCATE & DELETE
- sudha on What type of headers have to add in the mail function in which file a attached?
Tags
Basis Interview Questions Classic Job Interview Questions COBOL Interview Questions Database interview questions DBA Interview Questions FI Interview Questions HR Interview Questions interview questions for DBA Interview Questions on DBA Interview Questions on SAP Interview Questions On SAP ABAP Interview Questions on SQL MySQL interview questions Networking Informational Interview Questions Oracle Basics Interview Questions Oracle Interview Questions Oracle on Linux/Unix questions PP Interview Questions R/3 Interview Questions Sample Networking Informational Interview Questions SAP-Basis Interview Questions SAP-FI Interview Questions SAP-HR Interview Questions SAP-PP Interview Questions SAP-R/3 Interview Questions SAP-SD Interview Questions SAP Interview Questions SQL Interview Questions Tough Oracle Interview Questions Typical Interview Questions