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

Explain aggregate functions are available there in sql?

0 Answers  

there are .......different types of serializability

1 Answers   Wipro,

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

What is the differnce between view and materialized view

4 Answers   TCS,

How do I remove sql plus from windows 10?

0 Answers  

What is compound trigger?

0 Answers  

What is sql mysql pl sql oracle?

0 Answers  

What is blind sql injection?

0 Answers  

Why do we use procedures in sql?

0 Answers  

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

Explain correlated query work?

0 Answers  

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

For more SQL PLSQL Interview Questions Click Here
Categories