Oracle Interview Question

sql syntax for loops and joins