Oracle interview question

Plsql query