Complex oracle queries

Some Playful, Complex & Amazing Queries

1. Query to get Financial or Yearly Calendar from desired date.
2. Query to print string in X formation.
3. Query to form diamond.
5. Query to form reverse diamond.
6. Query to generate mathematical tables using cartesian product / cross join.