How to enter special characters like "&" in oracle database?

Asked 2010-11-14T00:06:57.467

61

I want to insert special character & in my insert statement. My insert is:

INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14');

If I try to run this query I am getting a popup and it asks me to enter value for Oracle_14.

How can I enter special characters like & in the insert statement for oracle db?

sql database oracle-database oracle-sqldeveloper

Edit Report

1 Answer

-4

You can either use the backslash character to escape a single character or symbol

'Java_22 \& Oracle_14'

or braces to escape a string of characters or symbols

'{Java_22 & Oracle_14}'

answered 2010-11-14T00:36:46.217