Home » SQL & PL/SQL » SQL & PL/SQL » Tab Delimited (Oracle Database 11g -Oracle JDBC driver- Linux)
Tab Delimited [message #679324] Fri, 21 February 2020 11:00 Go to next message
enriquemans
Messages: 1
Registered: February 2020
Junior Member

Hi

Im trying to do a conversion from GroovyScript +"\t" + to Tab Delimited in Oracle SQL || chr(9) ||.
Any ideas of what I could be doing wrong here?

select statement

prdv.taxid || chr(9) || prdv.emailaddress || chr(9) || prdv.NPN || chr(9) || prdv.Name || chr(9) || cv.brokerid || Chr(9) || L.Licenseid
Re: Tab Delimited [message #679325 is a reply to message #679324] Fri, 21 February 2020 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Nothing seems wrong in what you posted.

[Updated on: Fri, 21 February 2020 11:06]

Report message to a moderator

Re: Tab Delimited [message #679326 is a reply to message #679325] Fri, 21 February 2020 12:04 Go to previous messageGo to next message
Bill B
Messages: 1950
Registered: December 2004
Senior Member
why do you think you did anything wrong. I see no error description or error code
Re: Tab Delimited [message #679334 is a reply to message #679324] Sat, 22 February 2020 08:31 Go to previous message
EdStevens
Messages: 1206
Registered: September 2013
Senior Member
enriquemans wrote on Fri, 21 February 2020 11:00

Hi

Im trying to do a conversion from GroovyScript +"\t" + to Tab Delimited in Oracle SQL || chr(9) ||.
Any ideas of what I could be doing wrong here?

select statement

prdv.taxid || chr(9) || prdv.emailaddress || chr(9) || prdv.NPN || chr(9) || prdv.Name || chr(9) || cv.brokerid || Chr(9) || L.Licenseid
That's not a SELECT statement. It's a snippit of the column projection of a SELECT statement.
How do you expect us to know what you are doing wrong when you don't show the actual, complete code, and don't tell us what errors or incorrect data you are getting? Can you debug code that you cannot see, when you don't know what you'd be looking for if you could see it? Neither can anyone else.
Previous Topic: Start Transactional Control in PL/SQL
Next Topic: Return defined column size of varchar and varchar2 data types
Goto Forum:
  


Current Time: Tue May 26 19:42:22 CDT 2020