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
Why is sharding used?
what is the difference between union and union all? : Sql dba
What is sql in oracle?
What are the uses of merge?
Is ms sql traffic encrypted?
How do I remove duplicates in two columns?
Is stored procedure faster than query?
Can a procedure in a package be overloaded?
What is the difference between join and natural join?
What is constant in pl sql?
What is hibernate and its relation to sql?
What is sql rowcount?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what is cursor. write example of it. What are the attributes of cursor.
What is the difference between Union and Union all. Which is faster.