Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NEWBIE ?: SQL command not properly ended
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