Home » SQL & PL/SQL » SQL & PL/SQL » search for "returns"
search for "returns" [message #418021] Wed, 12 August 2009 09:58 Go to next message
dior
Messages: 25
Registered: April 2009
Junior Member
Hi,

I tried to search all returns in a table. This works fine if I precisely call a column of my table like:

select * from _Stat ST
where ST.FILIN like '%'||chr(10)||'%';


But in my Table I have more than 20 Colums like the "Filin" Col.
How can I search in every Field for the return?

tried something like:

select * from B$E_Station st
where * like '%'||chr(10)||'%';



thx in advance
Re: search for "returns" [message #418025 is a reply to message #418021] Wed, 12 August 2009 10:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
List all columns with OR.

Regards
Michel
Re: search for "returns" [message #418027 is a reply to message #418025] Wed, 12 August 2009 10:08 Go to previous messageGo to next message
dior
Messages: 25
Registered: April 2009
Junior Member
well, that the OR option is an option is clear, but i like to have a more convenient solution.
with 10 colums is this no problem, but with 20+ or even more, it is very annoying.
Re: search for "returns" [message #418028 is a reply to message #418027] Wed, 12 August 2009 10:12 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't be so lazy, you just have to do it once.

Regards
Michel
Previous Topic: function vs procedure
Next Topic: Tune the query
Goto Forum:
  


Current Time: Thu Dec 08 12:51:42 CST 2016

Total time taken to generate the page: 0.26368 seconds