Welcome! Log In Create A New Profile

Section 7 Using the set operator (Practice Q3)

Posted by Clair

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

Clair

Section 7 Using the set operator (Practice Q3)
July 05, 2010 09:29PM

Registered: 15 years ago
Posts: 5
Rating: 0

Hi all,

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?

Clair

Reply Quote

BenVP

Re: Section 7 Using the set operator (Practice Q3)
July 06, 2010 03:46PM

Registered: 14 years ago
Posts: 198
Rating: 0

I would also like to know the correct format - had the same problem.

Thanks
Ben.