Interested to Buy Any Domain ? << Click Here >> for more details...
can we write stored function in out parameters? how to call
through select statement? how to written more than one
value plz give the exmple?
- 1 Answers
- 4855 Views
- I also Faced
- E-Mail Answers
Answer / shekharjchandra
Hope u mean the below question
can we write stored function in out parameters? how to call
through select statement? how to written more than one
value plz give the exmple?
As
can we write stored function in out parameters? how to call
through select statement? how to RETURN more than one
value plz give the exmple?
------
We can write stored function with both IN and OUT parameters.
We can call from select statement only if there is no OUT parameter in it, and that too the called function should not modify the table data what is referred in Select statement.
And other condition it should not return multiple values when it is referred in Select statement
In order to return more then one value you have to use OT parameters or return the value as record and loop through the returned values.
Regards
J
| Is This Answer Correct ? | 1 Yes | 1 No |
How can I see all tables in sql?
What is normalization in sql?
What is the difference between inner join and outer join?
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
How to move files from one directory to another in pl sql?
Explain scalar functions in sql?
What is recursive stored procedure?
Are subqueries faster than joins?
How many databases can sql express handle?
What are user defined functions?
How do I create a sql script?
How do I create an index in word?
-
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)
