Home » RDBMS Server » Server Utilities » Equivalent of "VBCRLF" in SQL Plus?
Equivalent of "VBCRLF" in SQL Plus? [message #231572] Tue, 17 April 2007 10:01 Go to next message
jra_kumar
Messages: 7
Registered: April 2007
Location: India
Junior Member
Hi,

In Vb, I'm using the replace function to remove the empty line by using this "VBCRLF" {replace(stringname,vbcrlf,""))

The same I want to use in sql plus {the vb procedure is written into sql procedure}. Please can you tell me the equivalent of this to use in the sqlplus?
Re: Equivalent of "VBCRLF" in SQL Plus? [message #231580 is a reply to message #231572] Tue, 17 April 2007 10:30 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
vbCrLf = chr(13)||chr(10)

Regards
Michel
Previous Topic: ORACLE error 19206
Next Topic: sql * loader
Goto Forum:
  


Current Time: Wed Jul 03 08:52:20 CDT 2024