RE: help needed

As simple as:

select * from
(select 'ptMASTER' , 'Master' col2 from dual  union
 select 'ptMKT' , 'Market' from dual
 union
 select 'ptOFFICE' , 'Office' from dual)

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> 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).