You must be trying to run the edit command ‘as a script’, which you cannot do. It has always worked for me, through version 10 and still does now in 11.6 but you must run it as a statement or snippet.
Other than that, there have been two glitches introduced with it since about 10.1 or 10.5 (I can’t remember exactly):
- It is finicky about where lines are split; it won’t work if you have a newline within an ‘IN’ clause; i.e the following doesn’t work
edit customer_tab where cust_id IN (100,
whereas this works:
edit customer_tab where cust_id IN (100,200,205)
- The ‘alter session set current_schema’ command doesn’t quite work in concert with the edit command anymore, such that when you are not logged in as the schema owner you still have to provide the schema name with the table WHEN YOU EDIT, even though you don’t have to for anything else. So if I’m logged in as my self and the schema owner is SCOTT you can do the following:
alter session set current_schema = ‘SCOTT’;
select * from DEPARTMENT; --don’t have to do SCOTT.DEPARTMENT
but if you want to update the table, and do
it will return data to the grid, but once you change it, it will complain that it can’t find the table (in your schema) and therefore instead you have to use
which then works.