number leading zeros

Can somebody tell me how to make a number column display exactly nine digits, including leading zeros if the number is less than nine digits long?

I also need to know how to change column headings, for example, change LNAME to 'Last Name', etc

I'm using Oracle 8

Thanks.
Tim K.
tmkong_at_buffalo.edu Received on Thu Nov 11 1999 - 09:32:30 CST