PL/SQL (MOSC)

MOSC Banner

special characters in SQL Query

edited Nov 17, 2015 10:06AM in PL/SQL (MOSC) 5 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center