ORA 00933 - SQL command not properly ended
Posted on 2008-10-10
Both of the following SQL statements give me the ORA 00933 error.
SELECT DISTINCT s.customer_name FROM depositor AS s WHERE NOT EXISTS ( (SELECT branch_name FROM branch WHERE branch_city = 'Brooklyn') EXCEPT (SELECT r.branch_name FROM depositor AS t, account AS r WHERE t.account_number = r.account_number AND s.customer_name = t.customer_name) );
SELECT t.customer_name FROM depositor AS t WHERE UNIQUE (SELECT r.customer_name FROM account, depositor AS r WHERE t.customer_name = r.customer_name AND r.account_number = account.account_number AND account.branch_name = 'Perryridge');
Any idea what is wrong with these query statements? Yes, this is part of a homework assignment. I am working on a graduate level database course and these two query statements have had me stumped for the last hour. I am not asking anyone to do my homework, but any suggestions or guideance would be greatly appreciated.