My notes and Other stuff:

The things, I came across. {{For my own reference}}

Showing posts with label Single quote. Show all posts
Showing posts with label Single quote. Show all posts

Thursday, 10 September 2009

How to insert single or double quote into Oracle DB?

 Using q-quote string syntax, It can be done

Example :

INSERT INTO T(test) 
values (q'[single's quote and "double" quotes]');
Posted by Thillakan at Thursday, September 10, 2009 No comments:
Labels: Double quotes, Insert, Oracle, Quotes, Single quote
Older Posts Home
Subscribe to: Posts (Atom)

Search

Blog Archive

  • ▼  2018 (1)
    • ▼  January (1)
      • Softwares & Tools
  • ►  2017 (2)
    • ►  September (1)
    • ►  April (1)
  • ►  2015 (4)
    • ►  April (1)
    • ►  March (2)
    • ►  February (1)
  • ►  2014 (5)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2013 (8)
    • ►  December (1)
    • ►  November (2)
    • ►  July (2)
    • ►  April (1)
    • ►  March (2)
  • ►  2012 (6)
    • ►  November (1)
    • ►  August (1)
    • ►  July (1)
    • ►  May (1)
    • ►  February (2)
  • ►  2011 (8)
    • ►  December (2)
    • ►  September (1)
    • ►  July (1)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2010 (3)
    • ►  December (1)
    • ►  June (1)
    • ►  April (1)
  • ►  2009 (30)
    • ►  December (1)
    • ►  November (5)
    • ►  October (4)
    • ►  September (15)
    • ►  August (3)
    • ►  June (1)
    • ►  March (1)
  • ►  2008 (7)
    • ►  November (4)
    • ►  October (2)
    • ►  September (1)
  • ►  2006 (1)
    • ►  November (1)

About Me

My photo
View my complete profile

My Profile

View Thillakan Sabanayakam's profile on LinkedIn

StackOverFlow


profile for Thillakan at Stack Overflow, Q&A for professional and enthusiast programmers
Ethereal theme. Powered by Blogger.