UPPER ( LOWER ("HELLO world"))

Output of the above function call is:

Output for the following function call is:

SELECT INITCAP('I have just-now reaCHed 7th floor of my home:my destination') from DUAL;

What will be the output of the following question?

SELECT SUBSTR('I LOVE MY INDIA',3,5) FROM DUAL;

Assuming Database is using a 2 Byte Character Set, What will be the output of the following Query?

SELECT LENGTHB('I AM A NISTIAN') FROM DUAL;

What will be the output of the following Query?

SELECT INSTR('NISTIAN ROCKS','i',3,1) FROM DUAL:

What is the output for the following query?

SELECT RPAD('INDIAN', 4, '.' ) FROM DUAL;

What will be the output of the following query?

SELECT LTRIM('BANDE MATARAM', 'BADM') FROM DUAL;

SELECT REPLACE('EGG FIRST OR HEN','EGH','PT') FROM DUAL

SELECT SUBSTR('12/11/2019', INSTR('12/11/2019','/',-1,1)+1) FROM DUAL;