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: why my dynamic sql statement failed?

Re: why my dynamic sql statement failed?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 16 Feb 2006 05:45:48 -0500
Message-ID: <e_Kdnb6Z1OBDymneRVn-hg@comcast.com>

<zlmei_at_hotmail.com> wrote in message
news:1140060243.075180.169090_at_g14g2000cwa.googlegroups.com...
: Did the row gets inserted into the table after you ran that pl/sql
: block? What is the result of
:
: select count(*) from dept
: where deptno=99
: and dname='sample';
:
: ? I assume you would see 1 in your case?
:
: Guang
:
:

hey, guang -- the locals prefer that you don't top-post

your reply was to my sample PL/SQL block, not to the OP, but, yes, that's the type of test the OP needs to do

++ mcs Received on Thu Feb 16 2006 - 04:45:48 CST

Original text of this message

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