Re: NEWBIE ?: SQL command not properly ended

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 28 Jan 2003 00:55:35 -0800
Message-ID: <a20d28ee.0301280055.4bcfdde@posting.google.com>

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!!!

The proper syntax is
select * from [<owner>.]table_name[@db_link]

You seem to have 2 owners prefixed.

To avoid depression on your side and to avoid annoyance in the group you would best check the sql reference manual at http://otn.oracle.com

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Jan 28 2003 - 02:55:35 CST