Re: help needed

Thanx Adary !
  I could not think in such simple way . Anyway thanx again..

Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, February 18, 2002 2:13 PM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shishir
  INET: shishir_at_agnisoft.com

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