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!

Extract integer values form a column

726285Oct 6 2009 — edited Oct 7 2009

Hello Experts,

I have an issue over here. I am amateur to databases. I want to create a function in oracle and use it in SQL to extract data.

For ex -

suppose I have a column 'x',
x
----
bvhsfh834346vejfbv
vvfh***123hdvb367--
fbvjkv 786jjdk-90*-++

---------------
I want a function to be used in the SQL while retrieving column 'X' should provide me the following output -

x
----
834346
123367
78690

For the same problem, what I do is, I have a VB Script in excel. Once I query the data, I export it to an excel file and run the program to get the above output.

But now I want to have a function in the db, that takes care of this problem while writing the query itself.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2009

Added on Oct 6 2009

6 comments

598 views