Interested to Buy Any Domain ? << Click Here >> for more details...
Can we interchange parameters in procedure while calling
- 1 Answers
- 7440 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vidya
If you name the parameter then you can interchange
otherwise you cannot. Like in the following example the
first case is positional and you cannot interchange. In the
second one its named and you can interchange.
Regular OraDatabase.standproc(102,'RAM'); -- Positional
OraDatabase.standproc(empno=>102,ename=>'RAM'); --Named
OraDatabase.standproc(ename=>'RAM',empno=>102);
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What packages(if any) has oracle provided for use by developers?
How to return multiple rows from the stored procedure?
Why is partition used in sql?
What is materialized view. What are different methods of refresh?
What operators deal with null?
What is trigger price?
What is int identity in sql?
What does count (*) do in sql?
How exception is different from error?
What is data profiling in sql?
Can we use joins in subquery?
What is sql injection vulnerability?
how to convert character strings to numeric values? : Sql dba
What is group by in sql?
Can we create view in stored procedure?
