Home » SQL & PL/SQL » SQL & PL/SQL » delete case sensetive
delete case sensetive [message #211090] Tue, 26 December 2006 04:27 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
little confused
cant we delete the data from table which is starting with upper case
i cant delete
delete author
where aut_name in ('suresh kumar','arun sheety');
or
delete author
where aut_name = 'suresh kumar'
and
aut_name = 'arun sheety';

i can delete with
delete author
where aut_name in ('Suresh Kumar','Arun Sheety');
or
delete author
where aut_name = 'Arun Sheety'

is this the data case sensitive
if so how can i delete with out knowing the case

thanxs
Re: delete case sensetive [message #211093 is a reply to message #211090] Tue, 26 December 2006 05:02 Go to previous messageGo to next message
sandeepshahare
Messages: 20
Registered: December 2006
Location: pune
Junior Member
if u dont know the data in the database are in which case (lower or upper case )then use upper or lower function with column name and give the condition in the same case.

ex where UPPER(emp_name) in('KING','KOCHAR');
LOWER(emp_name) in('king','kochar');
Re: delete case sensetive [message #211099 is a reply to message #211090] Tue, 26 December 2006 06:16 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
or you can use initcap(name) in your case but its advisable to use upper or lower
Previous Topic: sql*plus
Next Topic: select cntr from dual (?) where cntr between "20" and "25"
Goto Forum:
  


Current Time: Wed Dec 07 06:51:20 CST 2016

Total time taken to generate the page: 0.47149 seconds