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

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

What is pl sql code?

0 Answers  

Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

What are the advantages of sql? Explain

0 Answers  

What are its different types of dbms?

0 Answers  

What is difference between my sql and sql?

0 Answers  

What is the purpose of primary key?

0 Answers  

What is the difference among union, minus and intersect?

0 Answers  

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

What is the difference between subquery and correlated query?

0 Answers  

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories