Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between a query and strored procedure?
- 4 Answers
- 10193 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / srao
Query is nothing but a single statement to retrieve data
from one or more tables.
Procedure is nothing but the combinations of Different
queries.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What's the difference between a primary key and a clustered index?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
how to delete an existing column in a table? : Sql dba
What is the difference between inner join and outer join?
What is sql procedures and functions?
what are dynamic queries in t-sql? : Transact sql
What is the difference between sql and isql*plus?
Can a table contain multiple foreign key’s?
Why left join is used in sql?
How do I add a primary key to a table?
What are the three pl sql block types?
What is pl sql collection?
Is full outer join same as cross join?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the difference between having and a where in sql?
