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

How to assign a tablespace to a users in oracle?

578

---

What is user managed backup in Oracle?

601

---

What is the best way to do multi-row insert in oracle?

552

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

564

---

What are the attributes of cursor?

578

---

---

Can a parameter be passed to a cursor?

587

---

How many types of cluster table in Oracle?

565

---

How can I combine multiple rows into a comma-delimited list in oracle?

571

---

Differentiate between post-database commit and post-form commit?

534

---

Explain self joins in oracle?

548

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

614

---

How to update values on multiple rows in oracle?

591

---

How to build data dictionary view an new database?

522

---

How to create a new view in oracle?

597

---

material view and view disadvantages?

623

---