Answer Posted / raji_4u
stored procedure can not return a value using the return
statement. though a stored procedure can contain a return
statement but should not return a value.simply "return".
in a manner,stored procedure can return values to the
calling block through the OUT,INOUT parameter modes.
Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
How can you tell the difference between an index and a view?
Explain clause in sql?
What is difference between mysql and postgresql?
What is nvarchar max in sql?
How can you load microsoft excel data into oracle? : aql loader
Which are the different types of indexes in sql?
What is the purpose of cursors in pl/sql?
Is sql developer case sensitive?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Differentiate between pl/sql and sql?
What do you understand by case manipulation functions?
How many rows can sqlite handle?
What does sign mean sql?
What is mdf ldf and ndf?
How can we store rows in PL/SQL using array?