Re: Newbie to Oracle: Question on SQLPLUS

On Sat, 10 May 2003 13:48:43 +0800, CWT <cwtam_at_hotmail.com> wrote:

>Hi all,
>
>I have just installed Oracle 9i database standard server on a Mandrake
>Linux 9.1 PC. I am following a book to start the learning process. When
>I type the following SQL statement, an error message appears:
>
>SQL> select empno, ename, sal from emp where ename = ´SMITH´;
>select empno, ename, sal from emp where ename = ´SMITH´
> *
>ERROR at line 1:
>ORA-00933: SQL command not properly ended
>
>Is there any problem with the apostrophe ? I notice that when I type the
> apostrophe key, I need to press it twice for the apostrophe to appear
>on the screen. The same is also needed for the command prompt and text
>editor.
>
>I would be grateful if anyone could advise.
>
>Regards,
>
>CWT
You need the single quote, NOT the apostrophe (aka bckquote), so you need ', which doesn't match the character above.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat May 10 2003 - 01:43:17 CDT