Interested to Buy Any Domain ? << Click Here >> for more details...
Can we interchange parameters in procedure while calling
- 1 Answers
- 7546 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 do I partition a table in sql?
what is union? : Sql dba
How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
what is data integrity? : Sql dba
define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.
What are all the different normalization?
Does sql require a server?
what is auto increment? : Sql dba
Explain table and field in sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
How many triggers can be applied on a table?
Write the order of precedence for validation of a column in a table ?
-
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)
