DBMS_OUTPUT.PUT_LINE format: how to lineup all values
591556Sep 20 2007 — edited Sep 23 2007I have the code below:
DBMS_OUTPUT.PUT_LINE(‘ID LAST_NAME FIRST_NAME ANNUAL_SALARY TAX’);
DBMS_OUTPUT.PUT_LINE(‘__ _________ __________ _____________ ___’);
these 2 lines of printout worked ok. then I use a loop to display all values:
DBMS_OUTPUT.PUT_LINE(r_emp.id || ' ' || r_emp.last_name || ' ' ||
r_emp.first_name || ' ' || v_an_sal || ' ' || v_tax);
the values displayed in the loop are in a mess:
ID LAST_NAME FIRST_NAME ANNUAL_SALARY TAX
__ _________ __________ _____________ ___
1 Velasquez Carmen 30000 4350
2 Ngao LaDoris 17400 1710
3 Nagayama Midori 16800 1620
9 Catchpole Antoinette 15600 1440
10 Havel Marta 15684 1452.6
can someone please help me to line up all these vlaues along with the column names? thanks in advance
Message was edited by:
user588553