SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

syntax for number with decimal part in substr

781692Jul 8 2010 — edited Jul 10 2010

hi all,
I am using substr to write up to 13 character, but how to mention for the decimal part.

for example if i want to print emp_name upto 20 character then i have used
substr(emp_name,1,20)
i the same way i want to display emp_sal 5 digits with 3 decimals(after point)
plz suggest me the syntax?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2010

Added on Jul 8 2010

12 comments

7,270 views