OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Tab Delimited (Oracle Database 11g -Oracle JDBC driver- Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tab Delimited [message #679324]

Fri, 21 February 2020 11:00

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

Report message to a moderator

Re: Tab Delimited [message #679325 is a reply to message #679324]

Fri, 21 February 2020 11:03

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Bill B
Messages: 1971
Registered: December 2004

Senior Member

why do you think you did anything wrong. I see no error description or error code

Report message to a moderator

Re: Tab Delimited [message #679334 is a reply to message #679324]

Sat, 22 February 2020 08:31

EdStevens
Messages: 1376
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.

Report message to a moderator

Previous Topic:	Start Transactional Control in PL/SQL
Next Topic:	Return defined column size of varchar and varchar2 data types

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 07:01:07 CDT 2025