Replace Alternate Character in a String

SQL query to replace every alternate character in a string to capital.
Input string:- govardhana
I need output as gOvArDhAnA
And vice versa i.e, GOVARDHANA and required output as GoVaRdHaNa
Provide 2 separate queries for above scenarios

Interview Candidate
Sep 3rd, 2015
6
10411

SQL

Answer

Showing Answers 1 - 6 of 6 Answers

FARIDA

Sep 14th, 2015
Code
 

Muraleedhar Reddy B

May 21st, 2016

We can perform DML on the view when
1.View is built based on a single table
2.Primary key of the table should be availbale in select clause used for view
We can not perform DML on the view when
1. View is bulit on multiple tables
However we can use trigger for DML operations on multi table view

RAKHEE

May 30th, 2016
Code
 

Vishnu Doppalapudi

Jun 22nd, 2016

For Example consider EMP Table:
SELECT REPLACE(REGEXP_REPLACE(INITCAP(REGEXP_REPLACE(ENAME, (..), 1 )), (..), 1 ), , NULL) AS NAME FROM EMP;