Home » SQL & PL/SQL » SQL & PL/SQL » Row Wise in Column Wise (Oracle 9i, Windows XP)
Row Wise in Column Wise [message #357938] Fri, 07 November 2008 05:43 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member


SELECT A FROM ( 
 SELECT 'A' A FROM DUAL
 UNION 
 SELECT 'D' A FROM DUAL) 
 
 OUTPUT
 ------
 A
 D


I WANT TO GET OUTPUT AS COLUMN-WISE


CAN ANY ONE HELP ME

THANKS AND REGARDS
Re: Row Wise in Column Wise [message #357940 is a reply to message #357938] Fri, 07 November 2008 05:47 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

PIVOT

Smile
Rajuvan.
Re: Row Wise in Column Wise [message #357943 is a reply to message #357938] Fri, 07 November 2008 05:52 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and don't postin UPPER case.

Regards
Michel
Previous Topic: Urgent-ORA-01445
Next Topic: Data Dictionary table for script (DDL)
Goto Forum:
  


Current Time: Sat Dec 07 05:58:01 CST 2024