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 -> Re: Is commit necessary

Re: Is commit necessary

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 9 May 2005 14:36:15 +0100
Message-ID: <MPG.1ce9779f79309f93989e62@news.individual.net>


In article <1115643917.758822.13610_at_o13g2000cwo.googlegroups.com>, Madhivanan says...
> I use both SQL Plus and SQL * Plus work Sheet
> I inserted records via SQL Plus and when I run the query
> Select * from test works well
> But the same query does not produce the result when running work sheet
> but displays records when coomiiting the transactions at SQL Plus. Is
> commit necessary?
>
> Madhivanan
>
>

To see the results in a different session (even if connected to the same oracle account) - yes.

-- 

jeremy
Received on Mon May 09 2005 - 08:36:15 CDT

Original text of this message

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