OraFAQ Forum: SQL & PL/SQL » Quotation Marks in SQL output

Home » SQL & PL/SQL » SQL & PL/SQL » Quotation Marks in SQL output

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

Quotation Marks in SQL output [message #347]

Wed, 06 February 2002 07:23

Roy Jeans
Messages: 2
Registered: February 2002

Junior Member

I have the following line in one of my PL/SQL programs:-
dbms_output.put_line ('Table_Data-Definition INBODY_SPECIFIC_7P3C37_I237AS_B')
It returns the following output:-
Table_Data_Definition INBODY_SPECIFIC_7P3C37_I237AS_B
The output I need is this:-
Table_Data_Definition 'INBODY_SPECIFIC_7P3C37_I237AS'
Note the single quotes around the INBODY etc etc
If I put the single quotes in the text string I want returned, the code bombs.
Can anyone help ?
Thanks in advance.

Report message to a moderator

Re: Quotation Marks in SQL output [message #349 is a reply to message #347]

Wed, 06 February 2002 08:33

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

use 3 single quotes as shown below

dbms_output.put_line ('''Table_Data-Definition INBODY_SPECIFIC_7P3C37_I237AS_B''')

Report message to a moderator

Previous Topic:	Get Last Command statement
Next Topic:	Indexes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 19 13:40:38 CDT 2025