Hi
Good time for all you.
I want to get formatted output as like
set colsep '|'
SET RECSEPCHAR "-"
SELECT 'B' AS U_TYPE, 2468492 AS COUNTU_TYPE FROM DUAL
UNION ALL
SELECT 'The long you type -abcdefg hijl mno pqrst uvwx yz ABCDEFGH IKJLMON PRSTUVWZYX', 274503 FROM DUAL
UNION ALL
SELECT 'XFC', 162560 FROM DUAL
UNION ALL
SELECT 'BBBB', 40019 FROM DUAL
UNION ALL
SELECT 'GSLBVIP', 1271 FROM DUAL
UNION ALL
SELECT 'BVIVIP', 46 FROM DUAL
UNION ALL
SELECT 'SLBVIP', 4 FROM DUAL'
+--------------------------------------------------------------------------------+-------------+
| U_TYPE | COUNTU_TYPE |
+================================================================================+=============+
| B | 2468492 |
+--------------------------------------------------------------------------------+-------------+
| The long you type abcdefg hijl mno pqrst uvwx yz ABCDEFGH IKJLMON PRSTUVWZYX | 274503 |
+--------------------------------------------------------------------------------+-------------+
| XFC | 162560 |
+--------------------------------------------------------------------------------+-------------+
| BBBB | 40019 |
+--------------------------------------------------------------------------------+-------------+
| GSLBVIP | 1271 |
+--------------------------------------------------------------------------------+-------------+
| BVIVIP | 46 |
+--------------------------------------------------------------------------------+-------------+
| SLBVIP | 4 |
+--------------------------------------------------------------------------------+-------------+
And if the text is too long like second row the above example it has to be wrapped out.. How?
Thanks