Home » SQL & PL/SQL » SQL & PL/SQL » escape charecter
escape charecter [message #222767] Tue, 06 March 2007 05:53 Go to next message
p.bhaskar
Messages: 33
Registered: February 2007
Location: kolkata
Member
anyone can give me the code to print single quote('') in sqlprompt?
Re: escape charecter [message #222770 is a reply to message #222767] Tue, 06 March 2007 05:57 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
SQL> select '''' from dual;

'
-
'

SQL>
Previous Topic: ORA-06502: PL/SQL: numeric or value error
Next Topic: there are two column state and city i want single column output like statewise city .
Goto Forum:
  


Current Time: Sun Dec 04 22:32:04 CST 2016

Total time taken to generate the page: 0.10236 seconds