Re: Complex search for a String

Franck HUGOT wrote:
>
> Ok thanks but is there a way not to specify columns?
>
> Connor McDonald <connor_mcdonald_at_yahoo.com> a écrit dans le message :
> 398FFCF8.4828_at_yahoo.com...
> > Franck HUGOT wrote:
> > >
> > > Hello,
> > >
> > > I would like to search a String in all columns of a table.
> > > I know I can do :
> > > select user_name from usertable where user_prenom='smith' or
> > > user_ville='smith' or user_alias='smith' or ....
> > >
> > > Is there a more simple way?
> > >
> > > Thanks in advance.
> >
> > where instr(col1||col2||col3||... , 'string') > 0
> >
> > HTH
> > --
> > ===========================================
> > Connor McDonald
> > http://www.oracledba.co.uk
> >
> > We are born naked, wet and hungry...then things get worse

You could use dynamic sql to get the column from user_tab_columns and then execute that...Not great but possible...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse