Oracle interview question

SQL related one question