René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
SQL Strings | ||
A string, in SQL, is delimited by an apostroph ('). So, in order to insert a String into a table, the following syntax is used:
insert into some_table values ('hello');
However, how would someone insert
hello I'm here ? Obviously, the following would be wrong:
insert into some_table values ('hello I'm here');
In order to have an apostroph within a string, two apostrophs are needed:
insert into some_table values ('hello I''m here'); |