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

Can pl sql procedure have a return statement?

Question Posted / raju paswan


Can pl sql procedure have a return statement?..

Answer / Snehil Srivastava

Yes, PL/SQL procedures can have a return statement. The RETURN statement is used to exit from a PL/SQL block early and optionally return a value that can be used in the calling program.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

what happens if null values are involved in expressions? : Sql dba

1 Answers  

What is a transaction?

5 Answers  

what is overloading procedure or overloading function ?

3 Answers   Genpact,

State some properties of relational databases?

1 Answers  

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

What is the current version of sql?

0 Answers  

What is trigger and types?

1 Answers  

What is sql profiler in oracle?

1 Answers  

What is set serveroutput on in pl sql?

1 Answers  

What is rownum?

1 Answers  

Is sql a scripting language?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories