Oracle interview question

Programs like, Second highest value from Array.