Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jeffshih
-
Qwest TnR (Transfer and Release)
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?- jeffshih
- Post #2
- Forum: Avaya: CM/Aura (Definity)
-
Help setting null character, tab delimiter, removing space padding
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'),'-')- jeffshih
- Post #3
- Forum: Oracle: All versions
-
Help setting null character, tab delimiter, removing space padding
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...- jeffshih
- Thread
- Replies: 2
- Forum: Oracle: All versions
