what is result in this query?
SELECT
'ORACLE SQL' STRING,
INITCAP(LOWER(SUBSTR('ORACLE SQL', -4,4))) LOWER
FROM DUAL;
What is result in this query?
SELECT
'ORACLE SQL' STRING,
SUBSTR('ORACLE SQL', 7,-3) SUBSTRING
FROM DUAL;
What is result in this query?
SELECT
'ORACLE' STRING,
LENGTH(SUBSTR('ANIMAL', -3, 15)) RESULT
FROM DUAL;
What is result in this query?
SELECT
'ORACLE SQL' STRING,
LPAD('ORACLE SQL' , 10, '*')
FROM DUAL;
What is result in this query?
SELECT
'SIVARAMUDU' STRING,
LPAD(RPAD('SIVARAMUDU', 01, '-'), 15, '*' ) RESULT
FROM DUAL;
What is result in this query?
SELECT
'SIVARAMUDU' STRING,
LTRIM(LTRIM(LPAD(RPAD('SIVARAMUDU',10), 10), 'RAMUDU'), 'SIVA') RESULT
FROM DUAL;
What is result in this query?
SELECT
TRIM(TRAILING 'R'FROM 'RRRSMITHRRR') RESULT
FROM DUAL;
Which function is used for appling extra charectors to the exising data eaither left side or right side?
What is result in this query?
SELECT
'SALES MAN' STRING,
REPLACE('SALES MAN', 'A', 'E') RESULT
FROM DUAL;
What is syntax of REPLACE function?
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
ROUND(123.456 +456.123, -3) ROUNDED
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
TRUNC(123.456 +456.123, -3) RESULT
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
TRUNC(ROUND(123.456 +456.123, -3),-2) RESULT
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
ROUND(TRUNC(123.456 +456.123, 3),-2) RESULT
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
TRUNC(ROUND(123.456 +456.123, 3),-2) RESULT
FROM DUAL;
Which function is finds the Position of a String Within a String?
Default result of PAD function?
SELECT LTRIM(‘Go Wolfpack’, ‘oGfW’)
FROM dual;
Which function is Clips out a Portion of a String?
Which one is Group function?
Which date function is used to find the difference between two dates?
Which function is used to find the largest integer less than or equal to a specific value?
What is the output of the following query?
SELECT TRUNC(1234.5678,-2) FROM DUAL;
What will be the output of the following query?
SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;
TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ?