Hi there
I've been using PLSQL on one pc, and I normally use a semicolon to separate my select statements, like below:
select * from fcislob.unitholderdealtbl;
SELECT * FROM FCISLOB.SYSPARAMTBL;
So whenever I pressed F8 to run a select statement, it would run the section between semicolons (where my cursor happened to be).
Now, I've been moved to an new pc... but when I try to do the exact same I've been doing for month on my old pc, it returns the ORA-00911 error. If I remove the semicolon and manually highlight the select statement I want to run, it works. However that is such a pain. I'm thinking it's a setting somewhere? Please can someone help.
Possibly related to this, I
I've been using PLSQL on one pc, and I normally use a semicolon to separate my select statements, like below:
select * from fcislob.unitholderdealtbl;
SELECT * FROM FCISLOB.SYSPARAMTBL;
So whenever I pressed F8 to run a select statement, it would run the section between semicolons (where my cursor happened to be).
Now, I've been moved to an new pc... but when I try to do the exact same I've been doing for month on my old pc, it returns the ORA-00911 error. If I remove the semicolon and manually highlight the select statement I want to run, it works. However that is such a pain. I'm thinking it's a setting somewhere? Please can someone help.
Possibly related to this, I