In addition, does anyone know how to get DTMF-# recorded at the end of the announcement (right after the toll-free digits) listed in the second vector above?
Thank you, Mufasa -- the nvl function did it!
I had to apply the to_char function to the non-char column (see below), but I was able to get the desired result.
nvl(to_char(signuptime,'DD-Mon-YYYY HH24:MI:SS'),'-')
Hello:
I'm using a script in SQL*Plus 8.1.6.0.0 to spool results in a very specific format. The formatting problem I'm having is getting all 3 of the following requirements met simultaneously:
1. trimming leading and trailing space padding for all columns, and
2. having a tab as my column...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.