Answer / Ms Varsha

The purpose of the primary key in SQL and PL/SQL is the same as stated in QNO: 325876.

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

How do you explain an index?

1 Answers  

---

What is recursive join in sql?

1 Answers  

---

How to know the last executed procedure?

1 Answers  

---

What is a Mapplet?

1 Answers   Informatica,

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

What does desc stand for?

1 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What are packages in pl sql and also explain its advantages?

1 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

how can i read files from a pl/sq l program

3 Answers  

---

What is sp_helptext?

1 Answers  

---