I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 6440 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the use of procedures?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What are pl/sql cursors?
What is the difference between mdf and ndf files?
What are local and global variables and their differences?
What is output spooling in sql*plus?
what is the difference between sql and t-sql? : Transact sql
Why do we use cursors?
What is the difference among union, minus and intersect?
What is the difference between the implicit and explicit cursors?
How is a PL/SQL code compiled?
Which one is faster ienumerable or iqueryable?
What is trigger price?
How do you define a foreign key?
What is java sql driver?
