Re: Oracle #1? Then why are these still missing...

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 29 Jul 1999 18:54:49 GMT
Message-ID: <37aca35e.114927006_at_newshost.us.oracle.com>


A copy of this was sent to AleX <korrozia_at_my-deja.com> (if that email address didn't require changing) On Thu, 29 Jul 1999 18:17:57 GMT, you wrote:

>In article <37a096e2.19069820_at_news.tcp.co.uk>,
> tkingsley_at_systemprot.com (Tom Kingsley) wrote:
>> >It has built in editing commands -- just use some of them like this:
>> >
>> >SQL> select * from a big typo here
>> > 2 ;
>> >select * from a big typo here
>> > *
>> >ERROR at line 1:
>> >ORA-00933: SQL command not properly ended
>> >
>> >
>> >SQL> 1
>> > 1* select * from a big typo here
>> >SQL> c/a big typo here/dual
>> > 1* select * from dual
>> >SQL> /
>> >
>> >D
>> >-
>> >X
>> >
>> >SQL>
>
>Actually, this function doesn't seem to work in 8.0.5
>
>
>FLO> select * from ddd;
>select * from ddd
> *
>ERROR at line 1:
>ORA-00942: table or view does not exist
>
>
>FLO> 1
> 1* select * from ddd
>FLO> c/a ddd/dual

FLO> c/ddd/dual

will work -- what is the "/a " from?

>String not found.
>FLO>

-- 
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Thu Jul 29 1999 - 20:54:49 CEST

Original text of this message