Executing multiple SQL statements
733833Nov 11 2009 — edited Dec 2 2009I'm using the SQL worksheet in JDeveloper to run SQL statements. JDeveloper won't run more than one statement at a time. Here's an easy example:
SELECT COUNT(*)
FROM TABLE1
WHERE PRICE IS NULL;
SELECT COUNT(*)
FROM TABLE1
WHERE PRICE > 0;
I get the following error when I submit multiple statements: ORA-00911: invalid character. I'm using the studio edition version 10.1.3.2.0.
Does Anybody know how to go around this or it is just that JDeveloper doesn't handle multiple statements?