What is the Result from this query?
SELECT
'ORACLE' STRING,
UPPER(LOWER(UPPER('ORACLE'))) UPPER
FROM DUAL;
What is result in this query?
SELECT
1234 NUM,
'STRING' STRING,
INITCAP(UPPER(LOWER('STRING'))) LOWER
FROM DUAL;
What is result in this query?
select
'ORACLE' STRING1,
'SQL' STRING2,
CONCAT('ORACLE', ' SQL') CONCAT
FROM DUAL
What is result in this query?
SELECT
'ORACLE ORACLE' STRING,
LOWER(SUBSTR('ORACLE ORACLE', 7)) LOWER
FROM DUAL;
What is result in this query?
SELECT
'ORACLE SQL' STRING,
INITCAP(LOWER(SUBSTR('ORACLE SQL', 4,0))) LOWER
FROM DUAL;
What is result in this query?
SELECT
'ORACLE SQL' STRING1,
'SQL ORACLE' STRING2,
'BASICS IN SQL' STRING3,
LENGTH(SUBSTR('BASICS IN SQL',-8)) RESULT
FROM DUAL;
What is result in this query?
SELECT
'ORACLE SQL' STRING1,
'SQL ORACLE' STRING2,
'BASICS IN SQL' STRING3,
LENGTH(SUBSTR('BASICS IN SQL', 0, 15)) RESULT
FROM DUAL
What is result in this query?
SELECT
'ORACLE ORACLE ORACLE' STRING,
INSTR('ORACLE ORACLE ORACLE', 'C', -3, 3) RESULT
FROM DUAL;
What is result in this query?
SELECT
'SSORACLESS' STRING,
INSTR('SSORACLESS' , 'SS', -8)
FROM DUAL;
What is syntax of INSERT function?
What is Result in this query?
SELECT
'SIVARAMUDU' STRING,
LPAD(RPAD('SIVARAMUDU',15,'-'), 20, '*') RESULT
FROM DUAL;
What is result in this query?
SELECT
'SIVARAMUDU' STRING,
LPAD(RPAD('SIVARAMUDU', 01 , '-' ), 01, '*') RESULT
FROM DUAL;
What is result in this query?
SELECT
'SIVARAMUDU' STRING,
RTRIM(LTRIM(LPAD(RPAD('SIVARAMUDU',10), 4), 'A'), 'RAMUDU') 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 eliminating unwanted data which is existing in original data eaither on left or right side?
What is result in this query?
SELECT
'TRAILING' STRING,
REPLACE('TRAILING', 'RI', 'BL') RESULT
FROM DUAL;
What is result in this query?
SELECT
'SALES MAN' STRING,
TRANSLATE('MANAGER', 'GREEN', 'N') RESULT
FROM DUAL;
What is result in this query?
SELECT
'SALES MAN' STRING,
TRANSLATE('MANAGER', 'MA', 'M A') RESULT
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
ROUND(123.456 +456.123, -2) ROUNDED
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
TRUNC(123.456 +456.123, 1) RESULT
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
TRUNC(123.456 +456.123, -1) RESULT
FROM DUAL;
What is result in this query?
SELECT
123.456 NUM1,
456.123 NUM2,
TRUNC(123.456 +456.123, -2) RESULT
FROM DUAL;
What is result in this query?
SELECT
'SIVARAMUDU' STRING,
SUBSTR('SIVARAMUDU', 4.55, 5.65) SUBSTRING
FROM DUAL;
SYSDATE IS 3/13/2011 12:28:10 AM, What is result in this query?
SELECT
'SYSDATE' TODAY,
SYSDATE + 3 "AFTER 3 DAYS",
ADD_MONTHS(SYSDATE, 2),
ADD_MONTHS(SYSDATE, -2),
NEXT_DAY(SYSDATE, '') RESULT,
LAST_DAY(SYSDATE)
FROM DUAL;