dbTalk Databases Forums  

TAB in the output of DBMS_output.put_line???

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss TAB in the output of DBMS_output.put_line??? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andre
 
Posts: n/a

Default TAB in the output of DBMS_output.put_line??? - 07-16-2003 , 12:19 AM






Hello all,

I want (using the DBMS_output.put_line) create a table using a oracle package.
So, i need to insert a TAB or something in the DBMS_output.put_line-code

Does soemone know??

Regards,
Andre

Reply With Quote
  #2  
Old   
sybrandb@yahoo.com
 
Posts: n/a

Default Re: TAB in the output of DBMS_output.put_line??? - 07-16-2003 , 04:45 AM






avanrossem (AT) hotmail (DOT) com (Andre) wrote in message news:<4d32d1be.0307152119.68ecaf5b (AT) posting (DOT) google.com>...
Quote:
Hello all,

I want (using the DBMS_output.put_line) create a table using a oracle package.
So, i need to insert a TAB or something in the DBMS_output.put_line-code

Does soemone know??

Regards,
Andre
I would do the following
- use chr(8)
- Go back to your school and ask your money back: they didn't learn
you anything
- Stop posting elementary questions in this and other Oracle forums.
This is NOT the place to get free Oracle courses or to be spoon fed.

Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #3  
Old   
andrewst
 
Posts: n/a

Default Re: TAB in the output of DBMS_output.put_line??? - 07-16-2003 , 04:51 AM




Originally posted by Andre
Quote:
Hello all,

I want (using the DBMS_output.put_line) create a table using a oracle
package.
So, i need to insert a TAB or something in the
DBMS_output.put_line-code

Does soemone know??

Regards,
Andre
The TAB character has ASCII code 9, so CHR(9) can be used:

SQL> exec dbms_output.put_line('a'||chr(9)||'b'||chr(9)||'c' )
a b c

PL/SQL procedure successfully completed.

Is that what you meant? I can't see the connection to creating a table.

--
Posted via http://dbforums.com


Reply With Quote
  #4  
Old   
Daniel Morgan
 
Posts: n/a

Default Re: TAB in the output of DBMS_output.put_line??? - 07-16-2003 , 10:32 AM



sybrandb (AT) yahoo (DOT) com wrote:

Quote:
avanrossem (AT) hotmail (DOT) com (Andre) wrote in message news:<4d32d1be.0307152119.68ecaf5b (AT) posting (DOT) google.com>...
Hello all,

I want (using the DBMS_output.put_line) create a table using a oracle package.
So, i need to insert a TAB or something in the DBMS_output.put_line-code

Does soemone know??

Regards,
Andre

I would do the following
- use chr(8)
- Go back to your school and ask your money back: they didn't learn
you anything
- Stop posting elementary questions in this and other Oracle forums.
This is NOT the place to get free Oracle courses or to be spoon fed.

Sybrand Bakker
Senior Oracle DBA
Relax my friend ... and BTW ... it is CHR(9) ... not 8.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)




Reply With Quote
  #5  
Old   
Sybrand Bakker
 
Posts: n/a

Default Re: TAB in the output of DBMS_output.put_line??? - 07-16-2003 , 01:22 PM



On Wed, 16 Jul 2003 08:32:49 -0700, Daniel Morgan
<damorgan (AT) exxesolutions (DOT) com> wrote:

Quote:
Relax my friend ... and BTW ... it is CHR(9) ... not 8.
Next time I will flame the moron in Dutch, so you can't understand it.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address


Reply With Quote
  #6  
Old   
Daniel Morgan
 
Posts: n/a

Default Re: TAB in the output of DBMS_output.put_line??? - 07-16-2003 , 02:36 PM



Sybrand Bakker wrote:

Quote:
On Wed, 16 Jul 2003 08:32:49 -0700, Daniel Morgan
damorgan (AT) exxesolutions (DOT) com> wrote:

Relax my friend ... and BTW ... it is CHR(9) ... not 8.

Next time I will flame the moron in Dutch, so you can't understand it.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address
Merci!

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.