Re: NEWBIE ?: SQL command not properly ended

Sybrand,

I'm sorry to subject you to such a simple question. I should have known that these newsgroups where only for Senior Oracle DBA's who already know everything. I put "NEWBIE ?" in the subject to avoid annoying those who don't want to be bothered with people just getting familiar with Oracle. Anyway thanks for the info it turned out between your post and the others in this thread I was able to figure out my problem.

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0301280055.4bcfdde_at_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 Wed Jan 29 2003 - 21:14:58 CST