Answers for "oracle get third word in string"

Whatever

0

oracle get third word in string

SELECT str, 
REGEXP_SUBSTR (str, '[^ ]+', 1, 3)   AS word_3
	FROM tbl_data; 
-----------------------------
SELECT str, 
REGEXP_SUBSTR(str, '\w+',1,3) AS emp_no
	FROM tbl_data;

Posted by: Guest on March-08-2022

Code answers related to "oracle get third word in string"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#