Answer Posted / tilak
1)we can write COMMIT in procedure but we cant write in function
2) function must me return a value but procedure may or may
not be
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is output spooling in sql*plus?
What are the advantages of sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is a file delimiter?
What is sql rowcount?
How many sql statements are used? Define them.
What is the difference between row level and statement level trigger?
What is the reports view in oracle sql developer?
What are the different parts of a package?
What is where clause in sql?
How do I order columns in sql?
Can a table contain multiple primary key’s?
Explain select statements in sql?
How do you change a value in sql?
