Query

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Sun, 30 Sep 2001 02:45:43 -0700
Message-ID: <F001.0039CCCF.20010930024517@fatcity.com>

Hi gurus,

My table data looks like as follows:

scott_at_ORCLSVR.QTEL.COM.QA> select * from t;

      ID P1 PVAL1 P2 PVAL2 P3 PVAL3

-------- - -------------------- - -------------------- -
--------------------
     101 A VALUE A              B VALUE B              C VALUE C
     102 X VALUE X              Y VALUE Y              Z VALUE Z
     103 P VALUE P              Q VALUE Q              R VALUE R

scott_at_ORCLSVR.QTEL.COM.QA>

Tab Description:
scott_at_ORCLSVR.QTEL.COM.QA> desc t;

 Name                            Null?    Type
 ------------------------------- -------- ----
 ID                                       NUMBER
 PCD1                                     CHAR(1)
 PVAL1                                    VARCHAR2(20)
 PCD2                                     CHAR(1)
 PVAL2                                    VARCHAR2(20)
 PCD3                                     CHAR(1)
 PVAL3                                    VARCHAR2(20)

I need output as like:

ID Pcd PVAL
101 A VALUE A
101 B VALUE B
101 C VALUE C
102 X VALUE X
102 Z VALUE Z
102 Y VALUE Y
103 P VALUE P
103 R VALUE R
103 Q VALUE Q Anyone have any idea .... pls.

Rgds,
Nirmal.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nirmal Kumar Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Sep 30 2001 - 04:45:43 CDT