PRINTING RESULT WITH LEADING ZEROS

[sdonal1507]

I am using a java program to retrieve information from Oracle Database.

The valus is stored in a result string and printed to file. I want to pad the number with leading zeros.

sql command: SELECT LPAD(PAS_ID,9,'0') FROM PA_COURSES WHERE PAS_ID = '121345';
This returns the value in the format that I need: 000121345

When attempting to run this statement through java I get:
column not found error.

Does anyone know of a better way to format using java?

[[deleted]]

Hello there,

this is a PHP forum!
For java problems, go to a java forum. 🙂

[Anon]

What vincent says is correct.

srini