OraFAQ Forum: SQL & PL/SQL » How to add Quotes while inserting a record

Home » SQL & PL/SQL » SQL & PL/SQL » How to add Quotes while inserting a record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to add Quotes while inserting a record [message #20915]

Mon, 01 July 2002 07:58

Vinod
Messages: 76
Registered: April 1999

Member

Hi all,

I am new to oracle and i would like to know how to add quotes while inserting a record in a table. For Example i want to add value called Ambassador's Authority into a column.

Thanks
kumar

Report message to a moderator

Re: How to add Quotes while inserting a record [message #20916 is a reply to message #20915]

Mon, 01 July 2002 08:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> ed
Wrote file afiedt.buf

  1  insert into test values
  2* ('Ambassodor''s authority')
SQL> /

1 row created.

SQL> select * from test;

NAME
------------------------------
castra'de augurta
Ambassodor's authority

Report message to a moderator

Re: How to add Quotes while inserting a record [message #20919 is a reply to message #20915]

Mon, 01 July 2002 13:05

motiram
Messages: 21
Registered: January 2001

Junior Member

Insert into table values ('Ambassador''s Authority')

Report message to a moderator

Re: How to add Quotes while inserting a record [message #20932 is a reply to message #20915]

Tue, 02 July 2002 05:24

pk
Messages: 12
Registered: September 2000

Junior Member

SQL> create table names
2 (desig varchar2(20));

Table created.
SQL> insert into names
2 values('Ambassador''s');

1 row created.

SQL> select * from names;

DESIG
--------------------
Ambassador's

Cheers
pkd

Report message to a moderator

Previous Topic:	Initializing a plsql table
Next Topic:	Rownum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:02:00 CDT 2024