Home » SQL & PL/SQL » SQL & PL/SQL » Inserting text field values that contain apostrophes
Inserting text field values that contain apostrophes [message #8131] Tue, 29 July 2003 07:49 Go to next message
Mark Grimshaw
Messages: 73
Registered: June 2002
Member
Hello,

I would like to be able to insert values that contain
apostrophes into a table that has a field declared as
a VARCHAR2(10), e.g. 'O'Brien'.

Does anyone know of the approach to take?

TYIA

Mark Grimshaw

Report message to a moderator

Re: Inserting text field values that contain apostrophes [message #8133 is a reply to message #8131] Tue, 29 July 2003 10:28 Go to previous message
Praveen
Messages: 57
Registered: November 2001
Member
'O''Brien'

Put two apostrophes instead of one.

Report message to a moderator

Previous Topic: complex query!help me!!
Next Topic: Utl_file error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 21:41:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.