SQL:
DO YOU KNOW ABOUT TRIM FUNCTION?
WHAT IS LTRIM AND RTRIM?
DO YOU KNOW ABOUT PADDING THEN WHAT IS LPAD AND RPAD?
WHAT IS INSTR FUNCTION
WHAT IS SUBSTR FUNCTION
WHAT IS DIFFERENCE BETWEEN UNION AND UNION ALL
WHAT IS DIFFERENCE BETWEEN ROWID AND ROWNUM
WHAT IS ROW_NUMBER() FUNCTION THEN WHAT IS THE USE OF OVER() CLAUSE.
DO YOY KNOW ABOUT JOINS IN SQL?
WHAT IS FULL OUTER JOIN
WHAT IS THE GROUP BY CLAUSE?
WHAT IS THE USE OF HAVING CLAUSE WITH GROUP BY
WHAT IS PSEDOCOLUMNS
For HCL interview questions :
• HCL interview questions on SQL and PLSQL
For CTS interview questions:
• CTS interview questions on Oracle SQL and ...
For Global analytics interview questions:
• Global Analytics - Interview questions on ...
please subscribe to my channel for more interview questions and answers.
/ @oracleplsqltalendetl6946
Thanks !!!