I need to write a simple query,which one is better select
statement or stored procedure?and why?
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 out parameter used for eventhough return statement can also be used in pl/sql?
What is sp_helptext?
what is a database lock ? : Sql dba
What is difference between inner join and self join?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is rank function in sql?
Can delete statement be rollbacked?
What are the different types of dbmss?
What is the difference between distinct and unique in sql?
Does inner join remove duplicates?
what is difference between delete and truncate commands? : Sql dba
What is a function in oracle pl sql?
What are the two types of periodical indexes?
What is a primary key called that is made up of more than one field?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?