can we pass two out parameters at a time in function?please
answer to my question
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nathan
Yes,We can pass two out parameters in a function, but there
should at least one in parameter, because using the in the
function will do something.It'll not throw any errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohit
Yes, we can pass two OUT parameters in a functions. Also
you can use there two OUT parameters in calling function as
well.
| Is This Answer Correct ? | 1 Yes | 1 No |
How to define an anonymous procedure with variables?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
interview questions with answer for cts
Explain alias?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
What privilege is needed for a user to create indexes in oracle?
which is the best training centre for learning oracle?
What is Private Database Link ?
What are the components of Logical database structure of ORACLE database?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to rename a column in an existing table?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??