Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Escape Special Characters in SQL statements
How To Escape Special Characters in SQL statements? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
There are a number of special characters that needs to be escaped (protected), if you want to include them in a character string. Here are some basic character escaping rules:
Here are some examples of how to include special characters:
SELECT 'It''s Sunday!' FROM DUAL; It's Sunday! SELECT 'Allo, C\'est moi.' FROM DUAL; Allo, C'est moi. SELECT 'Mon\tTue\tWed\tThu\tFri' FROM DUAL; Mon Tue Wed Thu Fri
2007-05-11, 7157👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - Where do you specify session state mode in ASP.NET ? The following code e...
How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions To...
Write down the equivalent pointer expression for referring the same element a[i][j][k][l]? a[i] == *...
What is AL.EXE and RESGEN.EXE? In the previous question you have seen how we can use resource files ...
1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how...