Re: Newbie to Oracle: Question on SQLPLUS

From: CWT <cwtam_at_hotmail.com>
Date: Sat, 10 May 2003 17:20:19 +0800
Message-ID: <b9ig7c$riv74@imsp212.netvigator.com>

Sybrand Bakker wrote:

> 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

After changing the keyboard setting from US(international) to US, I can now type the single quote '. Before that I can only type ´.

Thank you.

CWT Received on Sat May 10 2003 - 04:20:19 CDT