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:

Sample Java Codes - Part 6

Code 34: Composition

Code a:


public class Test{
public static void main(String args[]){
Class3 Class3Object = new Class3(4,5,6);

}
}