Difference between a query and strored procedure?
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 are few of the schema objects that are created using PL/SQL?
What is the primary key?
what is a trigger in mysql? : Sql dba
What is type and rowtype in pl sql?
How do I kill a query in postgresql?
Why does sql need a server?
Why we use joins in sql?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
what is bcp? When is it used?
What is record in pl sql?
What is cross join sql?
What is left join in sql?
Does execute immediate commit?
What is sql profiler in oracle?
What is union and union all keyword in sql and what are their differences?