Can we interchange parameters in procedure while calling
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 do you mean by query optimization?
What is 19 null in sql?
What is trigger in flip flop?
discuss about myisam key cache. : Sql dba
what is the difference between primary key and unique key? : Sql dba
How to revise and re-run the last sql command?
What are the different type of joins in sql?
What is the clause we need to add in function body to return variable?
What is function and procedure in pl sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is a clob in sql?
What is union?
Does sql require a server?
What is the use of sqlerrd 3?
Explain the difference in execution of triggers and stored procedures?