Re: NEWBIE ?: SQL command not properly ended

I havent got Oracle on my machine and unaware on how your tables are named but the simple statement you supplied looks dodgy.

> SELECT * FROM EMX.HR.DEPARTMENT;
Your doing a SCHEMA.??.TABLENAME where it sould be SCHEMA.TABLENAME. Should it be

SELECT * FROM EMX.HR_DEPARTMENT; ?? Mark

speedback_at_rocketmail.com (Steve) wrote in message news:<1be7a470.0301271930.5f17b8c5_at_posting.google.com>...
> I just installed Oracle 9i Personal edition on my Windows XP Pro
> laptop and am having a difficult time getting going. Just to test out
> some queries I tried running a extremely simple SQL statement against
> the database:
>
> SELECT * FROM EMX.HR.DEPARTMENT;
>
> When executing the query I get ERROR at line 1: ORA-00933: SQL command
> not properly ended. Someone help, I'm getting depressed that I can't
> execute the simplest of queries!!!
Received on Tue Jan 28 2003 - 03:36:58 CST