Home » SQL & PL/SQL » SQL & PL/SQL » The ESCAPE Option
The ESCAPE Option [message #681062] Wed, 10 June 2020 06:28 Go to next message
amirmg
Messages: 4
Registered: June 2020
Junior Member
I cannot understand the last line of the following code. Could you pleas let me know what is result of the following code?
SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id LIKE ’%SA\_%’ ESCAPE ’\’;

I also need the format of the ESCAPE code.

Thanks,
Amir
Re: The ESCAPE Option [message #681063 is a reply to message #681062] Wed, 10 June 2020 07:20 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Re: The ESCAPE Option [message #681064 is a reply to message #681062] Wed, 10 June 2020 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 67367
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

SQL Language Reference, LIKE.

Re: The ESCAPE Option [message #681070 is a reply to message #681064] Wed, 10 June 2020 13:29 Go to previous messageGo to next message
Bill B
Messages: 1969
Registered: December 2004
Senior Member
Typically an underscore if a single character wildcard. However the escape clause gives you the ability to actually use the underscore or "%"

SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id LIKE '%SA\_%' ESCAPE '\';
where this means it to look for a job_id that contains the string "<any characters>SA_<ANY CHARACTERS>"

Without the ESCAPE you would be searching for "<any characters>SA<any single character><ANY CHARACTERS>"
Re: The ESCAPE Option [message #681077 is a reply to message #681063] Fri, 12 June 2020 01:10 Go to previous messageGo to next message
amirmg
Messages: 4
Registered: June 2020
Junior Member
Dear BlackSwan,

Thank you so much for your valuable links.
This was my first post here, and I was not familiar with the rules.

Regards,
Amir
Re: The ESCAPE Option [message #681078 is a reply to message #681064] Fri, 12 June 2020 01:13 Go to previous messageGo to next message
amirmg
Messages: 4
Registered: June 2020
Junior Member
Morning Michel,

Thank you for your care answering my question, and I also followed the link you sent me, but regrettably I cannot access Oracle website owing to to the imposed sanction to my country.

Regards,
Amir
Re: The ESCAPE Option [message #681079 is a reply to message #681070] Fri, 12 June 2020 01:16 Go to previous messageGo to next message
amirmg
Messages: 4
Registered: June 2020
Junior Member
Dear Bill B,

You answered my question completely. Thank you ever so much.

Regards,
Amir
Re: The ESCAPE Option [message #681081 is a reply to message #681078] Fri, 12 June 2020 02:29 Go to previous message
Michel Cadot
Messages: 67367
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
amirmg wrote on Fri, 12 June 2020 08:13
Morning Michel,

Thank you for your care answering my question, and I also followed the link you sent me, but regrettably I cannot access Oracle website owing to to the imposed sanction to my country.

Regards,
Amir
The question is now how could you have a product you should not. Wink

Previous Topic: Time Portion of Date/Time Value Being Stripped When Passed to Stored Procedure (3 merged)
Next Topic: get closer to datetime in two tables
Goto Forum:
  


Current Time: Wed Sep 23 02:18:10 CDT 2020