Oracle interview question

Pure technical from java and ql and ojet