ORACLE WORKING WITH SINGLE QUOTE

CREATE A SAMPLE TABLE WITH DATA  HAVING SINGLE QUOTE


CREATE TABLE  DEV_TEST
AS
SELECT 'FLOOR GROUND COMM''S ROOM' LOC  FROM DUAL

SELECTING THE DATA FROM EXISTING TABLE 
SELECT * FROM DEV_TEST

----OUTPUT --

LOC

FLOOR GROUND COMM'S ROOM

HOW TO SELECT DATA FROM TABLE WITH SINGLE QUOTE (')

TRY 

SELECT * FROM DEV_TEST WHERE LOC = 'FLOOR GROUND COMM'S ROOM'


----OUTPUT --
THIS WILL GIVE ERROR AS THE TEXT ENDS AT FIRST SINGLE QUOTE

CORRECT METHOD
SELECT * FROM DEV_TEST WHERE LOC = 'FLOOR GROUND COMM''S ROOM'

LOC

FLOOR GROUND COMM'S ROOM

SUMMARY :

• Double single quote can be used while selecting or inserting data with single quo