Answer Posted / vipul

column can be convert in row by using PIVOT function in ORACLE

for eg:

SELECT * FROM(SELECT VMENUNAME,NMENUNO FROM MENU_MASTER) A
PIVOT(MAX(VMENUNAME) FOR NMENUNO IN (6,7,8,9,10,11,1)) PVT

Differentiate between function and procedure in oracle.

1049

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2022

---

How to export your connection information to a file?

1114

---

Can we create database in oracle using command line ?

1058

---

Hi Can any one tell me what are the API's used in requisition import.

1909

---

How to retrieve data from an explicit cursor?

1037

---

WHAT IS ecc 6.0

2139

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2216

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3872

---

Explain about functional dependency and its relation with table design?

987

---

How will you identify oracle database software release?

983

---

What is where clause in oracle?

1010

---

How to write numeric literals in oracle?

1161

---

What is define in oracle?

1042

---

How to declare a local variable?

1095

---