Oracle – Example – Insert with QUOTE

How can we insert the value with QUOTE in the table?

In the insert statement use the two QUOTES to insert the single QUOTE as shown in the example.

Example:

-- CREATE A TEMP TABLE
CREATE TABLE TEMP
(
TEMP_COL VARCHAR2(255)
);

-- INSERT VALUE WITH QUOTE
INSERT INTO TEMP VALUES ('TOM''S HOUSE');

-- CHECK RESULT
SELECT * FROM TEMP;