special characters in SQL Query
Dear All,
if i have this organization_name : 'O/S & COUNTRY STN. MGRS' and i want its organization_id
query:
select name, organization_id from hr_all_organization_units where name like 'O/S & COUNTRY STN. MGRS'
it gives "Enter value for country:" because it contains special characters.
so how can i write it to take the value of the string as is.
please advise