How to Use SYS_CONNECT_BY_PATH in Oracle

SYS_CONNECT_BY_PATH :

Syntax:

SYS_CONNECT_BY_PATH is a function which is used in hierarchical queries to get the path for the current node starting from Parent node.

SELECT SYS_CONNECT_BY_PATH ( column , char)

FROM table_name

START WITH <root_node>

CONNECt BY NOCYCLE PRIOR < child_node_col> = <Parent_node>

How to replace Special Characters in Oracle

How to replace Special Characters in Oracle

Use regexp_replace (column_name,'[]~!@#$%^&*|?]', NULL ) to replace Special character .

New Blog for Selenium Automation

Hello

Please refer to below blog for any assistance required in Selenium Automation. Infact, you can Request the topic you want me to write about and i would be more than happy to add a blog on the same.

http://automationtesters007.blogspot.com.au/

Happy Learning
The Software Professionals.

How to convert single column to multiple rows in Oracle

Example 1 ->  Take the below Example :

CREATE TABLE config_value

(

   Config_id    VARCHAR2(40)

 , config_code    VARCHAR2(100)

);

How to use 'Case' statement in Oracle

Case Statement

Syntax:

CASE [ expression ]

   WHEN condition_1 THEN result_1

   WHEN condition_2 THEN result_2

   ...

   WHEN condition_n THEN result_n

   ELSE result

END

Let’s take few scenarios to Implement Case Statement: