Interested to Buy Any Domain ? << Click Here >> for more details...
I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 6891 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 does sign mean sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Is progress software supports to ( pl/sql )?
What is a natural join?
What is interval partition?
How do I copy a table in sql?
What is the limitation on the block size of pl/sql?
What operating systems are supported by oracle sql developer?
Which join is like inner join?
Why we use triggers in mysql?
Explain isolation levels. : Transact sql
What is scalar and vector?
Explain what is a view?
How do I view a sql database?
How is a PL/SQL code compiled?
