Home » SQL & PL/SQL » SQL & PL/SQL » Quotation Marks in SQL output
Quotation Marks in SQL output [message #347] Wed, 06 February 2002 07:23 Go to next message
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.
Re: Quotation Marks in SQL output [message #349 is a reply to message #347] Wed, 06 February 2002 08:33 Go to previous message
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''')
Previous Topic: Get Last Command statement
Next Topic: Indexes
Goto Forum:

Current Time: Mon Sep 27 05:29:20 CDT 2021