Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why my dynamic sql statement failed?
<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