Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hitendra yadav
We can return multiple records from procedure through
using reference cursor variable as out parameter of
procedure.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is sql and how does it work?
Will truncate release space?
How can you know that statistics should be updated?
What is the difference between the conventional and direct path loader? : aql loader
what is msql? : Sql dba
Is inner join faster than left join?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can you join a table to itself?
What is clustered index sql?
Is left join and outer join same?
How do I run a query in pl sql developer?
What are tables and fields?
List out the acid properties and explain?
Why we use triggers in mysql?
What is embedded sql in db2?
