Can we interchange parameters in procedure while calling
- 1 Answers
- 6669 Views
- TCS, I also Faced
- E-Mail Answers
Answer / 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 |
What are sql constraints?
what is the difference between cluster and non cluster index? : Sql dba
Which is faster truncate or drop?
What is clause in sql?
How many clustered indexes can you have?
What is relationship? How many types of relationship are there?
Can you sum a count in sql?
What is sql and how does it work?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Is primary key is clustered index?
Can triggers stop a dml statement from executing on a table?
What are the benefits of pl sql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
