Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SQLplus question unusual behavior
I am trying to update a small table from a remote table with sqlplus 9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen.
Am I suffering from a severe lack of caffine or is this really odd?
SQL> select count(*) from facility;
COUNT(*)
0
SQL> insert into facility (select * from facility_at_dev);
233 rows created.
SQL> select count(*) from facility;
COUNT(*)
0
SQL> commit;
Commit complete.
SQL> select count(*) from facility;
COUNT(*)
0
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Shaw INET: John.Shaw_at_correctionscorp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Mon Jan 20 2003 - 09:30:45 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
![]() |
![]() |