What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
Answer Posted / pratap557
In general SPs are sequential block of PL/SQL for
Transaction
Func are used for specific calculation / selection
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is executereader?
Explain the working of sql privileges?
What is a full text index?
What are the types of resultset?
What are the key configuration files for sql server reporting services ?
How can we determine what objects a user-defined function depends upon?
Do you know what are the reporting services components?
What is correlated subquery in sql server?
What is the difference between Clustered and Non-Clustered Index?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Define compound operators?
What does the on delete cascade option do?
what are the different types of SSRS reports?
What is the sql case statement used for? Explain with an example?
What is use of except clause?