Answer Posted / menan
declaration part;
begin
executable part;
exception handling;
end;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are database links used for?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How long does it take to learn pl sql?
Mention what are different methods to trace the pl/sql code?
What are the different dml commands in sql?
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 ?
Explain aggregate functions are available there in sql?
What are the advantages of pl sql over sql?
What are the different set operators available in sql?
How much does sql cost?
What are the query optimization techniques?
How do you sort in sql?
How many types of primary keys are there?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is database white box testing and black box testing?