can we pass two out parameters at a time in function?please
answer to my question
Answer Posted / abhisudipta
No, naturally we can't pass the two out parameter in a
function , because function will return only one value with
only specified data type in return statement. But we can do
with using the ref-cursor if I hold values through runtime
then we can return so many values.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the differences between interval year to month and interval day to second?
What is different types of joins?
How can we find out the current date and time in oracle?
Explain database link?
What is the purpose of save points in oracle database?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Give syntax for SQL and ORACLE joins.
What is set verify off in oracle?
Explain how you would restore a database using RMAN to Point in Time?
What is a cursor in oracle?
Explain the use of online redo log files in oracle.
Why cursor variables are easier to use than cursors?
How to compare dates in oracle sql?
What is a data lock in oracle?