What is a package ? What are the advantages of package ?

0 Answers  

---

Draw E-R diagram for many to many relationship ?

0 Answers   Keane India Ltd,

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

How to initialize variables with default values?

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---

What does a Control file Contain ?

2 Answers  

---

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

---

How you open and close a cursor variable.Why it is required?

2 Answers  

---

if you ctreate table identity

0 Answers  

---

Where do you use decode and case statements?

0 Answers  

---

what is insert all statement in sql

2 Answers   CGI, TCS,

---

How to write date and time interval literals in oracle?

0 Answers  

---