Newbie to Oracle: Question on SQLPLUS

From: CWT <cwtam_at_hotmail.com>
Date: Sat, 10 May 2003 13:48:43 +0800
Message-ID: <b9i3qk$jn61@imsp212.netvigator.com>

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 Received on Sat May 10 2003 - 00:48:43 CDT