Interested to Buy Any Domain ? << Click Here >> for more details...
Can we interchange parameters in procedure while calling
- 1 Answers
- 7556 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
Write a query to find the names of users that begin with "um" in sql?
How to run sql functions in pl/sql?
What is the difference between nvl function, ifnull function, and isnull function?
what is the bond code in materialized view?
What is the use of function in sql?
How do you break a loop in pl sql?
What does where 1 1 mean in sql?
What is the main reason behind using an index?
What is trigger types in sql?
What are the different types of dbms?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what is a primary key? : Sql dba
how to install mysql? : Sql dba
What are triggers and its uses?
What's the procedure?
