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 interchange parameters in procedure while calling

Question Posted / guntu


Can we interchange parameters in procedure while calling..

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

Post New Answer

More SQL PLSQL Interview Questions

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

What does varchar include?

0 Answers  

What are types of joins?

0 Answers  

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

How do I order columns in sql?

0 Answers  

How to select 10 records from a table?

0 Answers  

How to start oracle sql developer?

0 Answers  

What is the difference between clustered and non-clustered index in sql?

0 Answers  

What is Referential Integrity?

3 Answers  

What is nosql vs sql?

0 Answers  

Types of backups ?

3 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories