Skip to Main Content
Forums

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!

FIND ALL 10 DIGIT NUMBERS IN GIVEN STRING

683321Mar 1 2011 — edited Mar 1 2011
Hi~

I have a column called work log in my table which has some text and 10 digit numbers somewhere in the text, I need to find all the 10-digit numbers and convert those using

to_char(date '1970-01-01' + *"10-digit number"*/(60*60*24),'MM-DD-YYYY HH24:MI:SS')


Any Help


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2011
Added on Mar 1 2011
#11g, #9i, #data, #database, #dba, #oracle, #pl-sql, #plsql, #query, #sql, #sql-developer
5 comments
3,194 views