FARIDA

• Sep 14th, 2015

 

Code
 


SELECT REPLACE(govardhana,ovardhana,OvArDhAnA) FROM DUAL;


 

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
 SELECT XMLAGG(XMLELEMENT(E,NAME||)).EXTRACT(//text()) FROM 


 


 ( SELECT decode (mod(level,2),0, upper(SUBSTR(&A, LEVEL,1)),lower(SUBSTR(&A, LEVEL,1)))


  NAME FROM DUAL CONNECT BY LEVEL <=length(&A))A;

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;

Vishnu

• Jun 23rd, 2016

 

For Instance consider EMP Table.

Code
SELECT REPLACE(REGEXP_REPLACE(INITCAP(REGEXP_REPLACE(ENAME, (..), 1)), (..), 1),  , NULL) AS NAME FROM EMP;

Vishnu

• Jun 23rd, 2016

 

Code
SELECT REPLACE(INITCAP(REGEXP_REPLACE(ENAME, (..), 1 )),  , NULL) AS NAME FROM EMP;