Answer Posted / Yogesh Singh Garbyal
To insert or use a single quote within an Oracle SQL string, you should escape it by doubling the single quotes ('''). For example, if you want to insert 'O'Connor', you can do: `INSERT INTO EMPLOYEES VALUES ('''O'Connor''')`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
What is oracle latest version?
How to select all columns of all rows from a table in oracle?
