How to solve weird query results format

03/07/2013 Leave a comment

When you are using the SQL Plus and you want to copy the result to a tool like a text editor, you can obtain a result that doesn’t seems like in the SQL Plus:

TNAME                   TABTYPE    CLUSTERID
------------------------------ ------- ----------
BUSINESS_RULES               TABLE
DENSITY                TABLE
REVIEW                   TABLE
SOURCE                   TABLE
TARGET                   TABLE

This behavior is caused because the tab character is showed different between text editors. Here I show you how to fix “this problem”. Read more of this post

Filed under Other, SQL Tagged with , , , ,