Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
submask
--Oracle 11g Express Edition --please drop objects you've created at the end of the script --or check for their existance before creating --'\\' is a delimiter SELECT REGEXP_SUBSTR('255.255.255.255', '[0-9]+\.[0-9]+\.') AS "output 1" , REGEXP_SUBSTR('1.2.3.4', '[0-9]+\.[0-9]+\.') AS "output 2" from DUAL
run
|
edit
|
history
|
help
0
Srinivas
Rdbms
mr
oracle plan
cote corr
SQL for overlapping ranges
Srinivas
Oracle java
oracle-cast-to-varchar-without-precision
Srinivas