Identify the correct output --- select CONCAT('ORACLE' || 'BASICS') from dual;

Keep practicing — related questions

• Identify the correct output select INITCAP('ORACLE BASICS') from dual;
• Identify the correct output --- select SUBSTR('ORACLE BASICS',-6,5) from dual;
• SELECT CONCAT(SUBSTR('MINDWORKS',-5,6),SUBSTR('KNOWMAX',-3,4)) FROM DUAL;
• what is the output: select substr('Oracle Basics',-5,3) from dual
• What will be the output of- "Select 1 from dual UNION Select 'A' from dual"
• what is the concatenation operator in dbms_output.put_line() function
• Which of the query will print the output as 'TCS' (single quotes should come in the output)
• Which of the query will print the output as 'TCS' (single quotes should come in the output)