Home » RDBMS Server » Server Administration » a simple query regarding wildcard char's
a simple query regarding wildcard char's [message #56433] Sat, 29 March 2003 02:56 Go to next message
pavan kashyap
Messages: 6
Registered: March 2003
Junior Member
hello
i am having some data which has percentages + others in it
(eg:50%,45%,34%,5535,456,34,565 etc...)

now i want to write a query which can execute me only values
like xx%(50%,45%..) not the values like 456,453...

and even the same case with _(underscore) also.

eagerly waiting
pavan

Report message to a moderator

Re: a simple query regarding wildcard char's [message #56434 is a reply to message #56433] Sun, 30 March 2003 08:12 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello Mr.Pavan,
try to give the Query as bellow

Select * from table_name
where instr(col_name,'%')>0;

Ok ..
sai

Report message to a moderator

Previous Topic: trace specific to oracle user
Next Topic: how to know when the data is updated in the table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:24:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.