What is use of package in pl sql?

0 Answers  

---

What is scalar function in sql?

0 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

What is a cursor for loop ?

4 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

What is data modelling in sql?

0 Answers  

---

what are the limitations of identity column? : Transact sql

0 Answers  

---

what is the boundary line in varrays?

1 Answers   HCL,

---

What is dynamic sql in pl sql?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

How insert into statements in sql?

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  

---