I can't seem to get any PL/SQL commands to run in a SQL sheet. I am using SQL Developer with Oracle Express 11g and can run general SQL statements. Do I need to be running PL/SQL in a different form? I am copying the HR Schema Queries from here:
None of them are working and I'm guessing I need to change a setting.
Thanks for your help,
I am just trying to assume what your problem may be..
Use a "/" after your Declare-Begin-End Block and then place your cursor anywhere between your pl'sql block and hit "F9" from your SQL Developer.
Things should get fine then.
As far as your queries or blocks are concerned, I dont see any issues with them..