Can we interchange parameters in procedure while calling
- 1 Answers
- 7045 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
How do I find duplicates in the same column?
How many sql are there?
What is the difference between an inner and outer join?
Explain sql data types?
define join and explain different type of joins? : Sql dba
what is sql in mysql? : Sql dba
How do you write an index?
How many types of normalization are there?
Is clustered index a primary key?
Difference between table function and pipelined function?
What is compound trigger?
How do you explain an index?
Is sql scripting language?
How to look at the current sql*plus system settings?
Why do we use sql constraints?
