Interested to Buy Any Domain ? << Click Here >> for more details...
Can we interchange parameters in procedure while calling
- 1 Answers
- 7531 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 is trigger with example?
What are hotfixes and patches?
How we can update the view?
Does sql full backup truncate logs?
Can a commit statement be executed as part of a trigger?
What is the difference between between and in condition operators?
What is sql analyzer?
What is the difference between functions, procedures, and packages in pl/sql?
What are local and global variables and their differences?
Inline the values in PL/SQL, what does it mean.?
What pl/sql package consists of?
Is full outer join same as cross join?
What is the current version of sql?
Why should I use postgresql?
What is spool?
