Re: How to insert rows?

Peter wrote:

> 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?

Commit.

Check the Oracle's Concepts Manual (pdf/html docs) on transaction processing. This is the core essence of what database processing is all about.

--
Billy