I need to write a simple query,which one is better select
statement or stored procedure?and why?
- 2 Answers
- 6227 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
In what condition is it good to disable a trigger?
What is a primary key sql?
What is %type in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is delimiter in pl sql?
What is data abstraction in sql?
What is sql data?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What are tuples in sql?
How do you go back in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What information is needed to connect sql*plus an oracle server?
What do you mean by stored procedures?
What is insert command in sql?
