Oracle interview question

Programs and pseudo codes