Can someone please assist me with the Practice question no 3 in section 7 of book 1?
I tried running the solution as documented in the tutorial but Oracle gives me an error ORA-00900: invalid SQL statement.
If I take out the first and last lines "COLUMN dummy NOPRINT" and "COLUMN dummy PRINT" then it runs fine but the output shows the dummy column.
Is there another format of these statements for Oracle XE perhaps?