Interested to Buy Any Domain ? << Click Here >> for more details...
Can we interchange parameters in procedure while calling
- 1 Answers
- 7439 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 |
How to return multiple rows from the stored procedure?
Explain the the delete statements in sql?
What is pessimistic concurrency control? : Transact sql
What are the PL/SQL Statements used in cursor processing ?
How to find last day of the month in sql query
What are inbuilt functions in sql?
what is a record in a database ? : Sql dba
What is rank function in sql?
How to sort the rows in sql.
what is a database transaction? : Sql dba
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
