SQL - How do you get distinct records in SQL?

SQL - What do you know about UNION? Does it give distinct records?

SQL - Let's say we have some data in a column of a particular table, and that data contains some special characters or that data has some issues, then how would you fix it? (Hint - Use Regular Expression REGEXP)

PL/SQL - What do you know about Exceptions in PL/SQL? Name some predefined exceptions in Oracle.

PL/SQL - Let's say we have a PL/SQL block in which we have 2 Exceptions. 1) WHEN NO_DATA_FOUND THEN 2) WHEN OTHERS THEN. In the Exception part of the block, the exception - WHEN OTHERS THEN is written before WHEN NO_DATA_FOUND Exception. Then what kind of error do you get? Will the code work? (Hint - Compilation Error)

PL/SQL - What is the difference between a Stored Procedure and a Stored Function?

PL/SQL - What do you know about the statement - EXECUTE IMMEDIATE? (Hint: Dynamic SQL)

What do you know about PRAGMA AUTONOMOUS TRANSACTIONS?

Oracle Reports - What are the different types of Triggers used in Reports?

Oracle Reports - What are the use cases of all the different types of Triggers in Oracle Reports?

Oracle Reports - What do you know about XML Bursting?

Oracle EBS Apps (Functional) - What do you know about the O2C and P2P Cycle?

Oracle EBS Apps (Functional) - How do you link Sales Order (OM) Tables with Invoice (AR) Tables.