Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle #1? Then why are these still missing...

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@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 - 13:54:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US