Re: Please Help on Decode statement

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/11/12
Message-ID: <19971112173501.MAA26151@ladder02.news.aol.com>#1/1

>Hi Mujahid,
>
>using decode with the dual table will do what you want:
>select decode(v_name,'one'1,'two,2) from dual
>
>HTH,
>Peter
>
>

Yes sure, but now you are making a totally unnecessary trip to the database.

What's wrong with using IF anyway?

It's part of what a prcedural language is all about

John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

Received on Wed Nov 12 1997 - 00:00:00 CST