Answer / swapna

FWD declarations in package - the package has definition
and a body for procedures and funcs. a fwd declaration is
cosists simply of the program header, followed semicolon.
this header is declared in advance of the actual program
defination and the program is available for use even before
its definition.

What is the difference between unique and primary key constraints?

0 Answers  

---

What are some emotional triggers?

0 Answers  

---

Which is better join or subquery?

0 Answers  

---

What is compute?

0 Answers  

---

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 ?

0 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

what are the properties and different types of sub-queries? : Sql dba

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

Is delete faster than truncate?

0 Answers  

---

What is aggregate function in sql?

0 Answers  

---

What is materialised View?

2 Answers   IBM,

---