Find out parent and child relationship in the same table as Product and Sub Product or who reports to who kind of tree-based reports what method of joining techniques you would use. And provide answer with examples.
Under what circumstances must you include a GROUP BY clause in a query?
Describe the role of CASE and DECODE functions in SQL? Also explain what structures we use in PL/SQL program