PHP Code:
SQL> desc t1
Name Null? Type
----------------------------------- -------- ------------------------
NAME VARCHAR2(32)
ID NUMBER
CITY VARCHAR2(30)
STATE VARCHAR2(30)
SQL> set lines 70 pages 40 wrap on
before prompting
SQL> select * from t1;
NAME ID
-------------------------------- ----------
CITY STATE
------------------------------ ------------------------------
TAMIL 100
NEWYORK NEWYORK
SCOTT 200
ATLANTA GEORGIA
after formatting
SQL> get x
1 select rpad(name,32-length(name),'.')||' '||
2 to_char(id,900000)||' '||
3 rpad(city,30-length(30),'.')||' '||
4 rpad(state,30-length(state),'.') newrow
5* from t1
SQL> /
NEWROW
----------------------------------------------------------------------
TAMIL...................... 00100 NEWYORK..................... NEWYO
RK................
SCOTT...................... 00200 ATLANTA..................... GEORG
IA................
Hope this helps
Tamil