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

I need to write a simple query,which one is better select
statement or stored procedure?and why?

Question Posted / sujeethkumar

Answers were Sorted based on User's Feedback



I need to write a simple query,which one is better select statement or stored procedure?and why?..

Answer / sudipta santra

A simple query because through query we can throw the result
of the data based on conditions but in stored procedure we
can not , as the procedure is used for the specific time
based for the specific value return through out/IN out .

A simple query is best. But it is wrong that we can not do
through a proc, we can do but the effort will take more.

Is This Answer Correct ?    5 Yes 1 No

I need to write a simple query,which one is better select statement or stored procedure?and why?..

Answer / john

simple query s best as we can issue query by giving various
condition and it will not get stored in database where as a
procedure will get stored in database and gotta occupy
memory.so its waste of memory and time to create a
procedure rather than issuing a si9ngle query

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain select statements in sql?

0 Answers  

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

What is the difference between the implicit and explicit cursors?

0 Answers  

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

What is application trigger?

0 Answers  

how to create table with in the procedure or function?

2 Answers   Genpact, HCL,

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

What are the most important ddl statements in sql?

0 Answers  

how to write utl file pkg in SQL

1 Answers   Oracle,

For more SQL PLSQL Interview Questions Click Here
Categories