Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: help needed
As simple as:
select * from
Yechiel Adar, Mehish Computer Services
> -----Original Message-----
(select 'ptMASTER' , 'Master' col2 from dual
union
select 'ptMKT' , 'Market' from dual
union
select 'ptOFFICE' , 'Office' from dual)
adary_at_mehish.co.il
> From: Shishir [SMTP:shishir_at_agnisoft.com]
> Sent: Mon, February 18, 2002 9:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject: help needed
>
> Hi folks !
> I have some constants value i want to show then in tabular format with
> two cloumns and n rows
> is it possible to get them through in that way by manipulating SQL
> statements i dont want to define user defined data type
> i want the sql to be written in way that it ud give me result like :
> col1 col2
> 'ptMASTER' 'Master',
> 'ptMKT' 'Market',
> 'ptOFFICE' 'Office',
> 'ptPDCR' 'Producer',
> 'ptQUOTE' 'Quote',
> 'ptREGL' 'Regulator',
> 'ptROLE' 'Role',
>
> these are constant values and not stored in database at all .I ud
> appreciate any help from u gurus.
>
> thanx in advance....
> Shishir Kumar Mishra
> Agni Software (P) Ltd.,
> Bangalore-560055, India
> www.agnisoft.com <http://www.agnisoft.com>
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: adary_at_mehish.co.il 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 Mon Feb 18 2002 - 02:43:21 CST
![]() |
![]() |