</pre>
''Seung Yeon''
<pre>
If anyone know how to put these two lines
ROLLBACK;
select * from countries where flag IS NOT NULL;
after END; in pl/sql block please let me know how....
I finally figured out how to put set serveroutput on before DECLARE
but if i put those two lines after END; program doesnt work...
If you have same problem remove last two line and try
everything else should work fine.
This is Question 2
</pre>
<pre>
set serveroutput on
DBMS_OUTPUT.PUT_LINE('This region ID has MORE THAN ONE country without cities listed: ' || v_region);
END;
/
select * from countries where flag IS NOT NULL;
ROLLBACK;
select * from countries where flag IS NOT NULL;
/
</pre>
''Li Shi''