Oracle - how to display % sign in database column after number value

[nkshah]

Hi, friends,

i have very simple problem.

i want to display % sign in my database column value after calculation.

i tryied To_char() with formate $ is working and displaying
.

but i want to display % sign.

thanks.

 

[lbass]

There is a % icon in the toolbar. Select the field and then click on it.

-LB

 

[hilfy]

Another way is to Format Number on the field, turn on the Currency symbol, change the symbol to '%' and have it placed to the right of the number.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.