You can use REGEXP_REPLACE since Oracle 10: SELECT REGEXP_REPLACE(‘+34 (947) 123 456 ext. 2013’, ‘[^0-9]+’, ”) FROM DUAL This example returns 349471234562013. Alternative syntaxes include: POSIX character classes: ‘[^[:digit:]]+’ Perl-influenced extensions (since Oracle 11): ‘\D+’
the best explanation i’ve found is this: What is the difference betwen INTEGER and NUMBER? When should we use NUMBER and when should we use INTEGER? I just wanted to update my comments here… NUMBER always stores as we entered. Scale is -84 to 127. But INTEGER rounds to whole number. The scale for INTEGER … Read more
I found my java.exe that worked for SQL Developer at C:\ORACLE11G\product\11.2.0\client_1\jdk\bin where C:\ORACLE11G is my Oracle Home. The client that I have installed is 11.2.0. Hope this helps.
It is possible to connect to the database without specifying a password. Once you’ve done that you can then reset the passwords. I’m assuming that you’ve installed the database on your machine; if not you’ll first need to connect to the machine the database is running on. Ensure your user account is a member of … Read more