Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Escaping ampersand (&) in queries

51564Jan 23 2007 — edited Oct 11 2007
How do I escape an ampersand in a query executed in the SQL Worksheet in SQL Developer? For example if my query is:

SELECT * FROM EMPLOYEES WHERE status = 'Hired &Fired';

If I execute this query now in SQLD, it asks me to enter a parameter for &Fired, whereas in this case, ampersand is a value in the column status in this table.

Thanks for all the help,
Alex

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 8 2007
Added on Jan 23 2007
#sql-developer
14 comments
302,264 views