Oracle interview question

sql syntax for loops and joins