How to start instance with a minimal initialization parameter file?

0 Answers  

---

What are set operators?

0 Answers  

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

Define Transaction ?

5 Answers  

---

what is the difference between oracle enterprise edition and oracle express edition?

2 Answers  

---

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

---

how to hide the stored procedure inside a package

1 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  

---

After update how do u know how many records got updated

4 Answers   TCS,

---