Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to insert rows?
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