Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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?

Question Posted / rameshrevella


can we write stored function in out parameters? how to call through select statement? how to writt..

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

Post New Answer

More SQL PLSQL Interview Questions

Does a user_objects view have an entry for a trigger?

0 Answers  

what is schema? : Sql dba

0 Answers  

How can get second highest salary in sql?

0 Answers  

What is the sql*loader? : aql loader

0 Answers  

how to create temparary sequence

2 Answers   TCS,

what is autonomouse transaction?

3 Answers   Oracle,

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

What is procedure and function?

0 Answers  

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

What are the commands used in sql?

0 Answers  

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

What is application trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories