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!

LPAD negative numbers

651180Oct 21 2010 — edited Oct 21 2010

I creating a file and I am using the LPAD function, the number needs to be
like this -000000001750

my code is showing like 00000000-1750

LPAD (NVL (x.amount_due, '0000000000000'), 13, '0')

Also
I need to encryp5t a file with GPG using a pgp public key
I never done this, can somebody share the commands..
Thank you

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2010

Added on Oct 21 2010

6 comments

2,951 views