On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
> I have a table where users upload various data items via a web site. Some
> fields in the table are named DATA_ENC... to denote that the data should be
> encrypted uusing the encode function. This all works fine, however when I
> come to selecting the data from the table I would like to be able to select
> all the data and decrypt any fields as required. Is this possible with one
> query, or do I have to select every data item then decrypt it then present
> the data?
Wouldn't select decode(col1) from table work?