oracle - PL/SQL - printing a value -


i have field base has values example 0000000000. need print in txt file through stored procedure. data type char(10). while printing printing single value 0.

please give me suggestions correct this.

option1:

you should try using lpad function.

select lpad(columnname, 10, '0') yourtable; 

option2:

try forcing to_char while printing


Comments

Popular posts from this blog

google app engine - 403 Forbidden POST - Flask WTForms -

Android layout hidden on keyboard show -

Parse xml element into list in Python -