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 -> How to insert rows?

How to insert rows?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Tue, 27 May 2003 10:00:15 GMT
Message-ID: <4hd6dvo17pjuarmla2il0pdsiqjavs7tb7@4ax.com>


As SYS I inserted rows into peter's table

insert into peter.tabb
select * from SYS.tabb;

As SYS, when I ran

select * from peter.tabb;

I got the rows returned.

As peter,

  select * from peter.tabb;

does not return any rows.

Why is that?
Thanks Received on Tue May 27 2003 - 05:00:15 CDT

Original text of this message

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