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
Messages: 7
Registered: April 2007
Location: India
Junior Member

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: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
vbCrLf = chr(13)||chr(10)

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

Current Time: Tue Oct 25 00:01:47 CDT 2016

Total time taken to generate the page: 0.05749 seconds