Re: DECODE statement: is this a reasonable way to do things?

Hello ...

what do you think about

SELECT * FROM xtab
WHERE <column_name> = DECODE(p_newflag, 'Y', 17, <column_name>)

With this technique the length of the column_name does´nt matter ...

Greetings
Manfred Peter
(Alligator Company)
www.alligatorsql.com Received on Fri Jul 06 2001 - 07:24:11 CDT