Re: How to insert rows?

On Tue, 27 May 2003 12:05:15 +0000, Billy Verreynne <vslabs_at_onwe.co.za> wrote:

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

Yes, this was already done.

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

Actually, Peter was not logged on, so it was another account that was reading the rows.

Thanks Received on Tue May 27 2003 - 05:28:59 CDT