Wednesday, June 24, 2020

Oracle SQL Query to Print given Text as Row

SQL Query

 SELECT REGEXP_SUBSTR('Kalai, Oracle, Developer, From, 2012','[^,]+', 1, LEVEL) "Row"
   FROM DUAL
CONNECT BY REGEXP_SUBSTR('Kalai, Oracle, Developer, From, 2012', '[^,]+', 1, LEVEL) IS             NOT NULL

Output

Row
------------
Kalai
 Oracle
 Developer
 From
 2012

No comments:

Post a Comment

Oracle APEX - How to show Images in Oracle APEX Interactive Report

 In this post, I can explain how to show images in Oracle APEX interactive Report. Table Script CREATE TABLE BLOB_IMAGES (BI_IMG_DESC VA...