Answer Posted / menan

declaration part;
begin
executable part;
exception handling;
end;

What are database links used for?

988

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1175

---

How long does it take to learn pl sql?

999

---

Mention what are different methods to trace the pl/sql code?

1098

---

What are the different dml commands in sql?

1082

---

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 ?

954

---

Explain aggregate functions are available there in sql?

938

---

What are the advantages of pl sql over sql?

961

---

What are the different set operators available in sql?

972

---

How much does sql cost?

928

---

What are the query optimization techniques?

885

---

How do you sort in sql?

949

---

How many types of primary keys are there?

977

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1018

---

What is database white box testing and black box testing?

1045

---