Some improvements that I would value:
- Have an option to change the default tree-structure of different database elements appear as tabs at the top of that section (a bit of a TOAD rip off, but in my view the one thing TOAD does better than PL_SQL Dev). On selecting a tab (e.g. "Tables") the tables would be listed as normal below. Switching between tabs would no reset the current position / select of a table. I'm always flicking between tables and views for example, so this would constitute a more usable means of doing this.
- Full colour icons. Maybe even have these customisable or packageable? I stare at this program all day long, so subtle eye candy would be nice.
- Similar to the functionality in the "Describe" window, be able to right click the results of a query and copy just the headings or just the headings, comma-separated. This would be handy for filling in the details of mysterious *s in queries.
- Whilst not all queries are editable, some are by simply retyping ", x.rowid" where x is the table name in a query of a single table. If I've forgotten (or am just lazy) to put this then for the limited scenarios where it's possible, it would be nice for there to be a button to add this to the query automatically. Probably located next to the Edit Data button.
- I don't know if this is possible Oracle-wise in the first place, but it'd be great if it were possible to pause a program in debug mode after you've "let it go". I might start stepping through, and then hit the green triangle. After a few minutes of a large procedure I might wish to pause the code again (I might not be able to think of an elegant test scenario to break at, so the passing of time would be sufficient). A pause button would be handy if it's theoretically possible. Not sure if processing is essentially handed over to the db by then.
Many thanks.
- Have an option to change the default tree-structure of different database elements appear as tabs at the top of that section (a bit of a TOAD rip off, but in my view the one thing TOAD does better than PL_SQL Dev). On selecting a tab (e.g. "Tables") the tables would be listed as normal below. Switching between tabs would no reset the current position / select of a table. I'm always flicking between tables and views for example, so this would constitute a more usable means of doing this.
- Full colour icons. Maybe even have these customisable or packageable? I stare at this program all day long, so subtle eye candy would be nice.
- Similar to the functionality in the "Describe" window, be able to right click the results of a query and copy just the headings or just the headings, comma-separated. This would be handy for filling in the details of mysterious *s in queries.
- Whilst not all queries are editable, some are by simply retyping ", x.rowid" where x is the table name in a query of a single table. If I've forgotten (or am just lazy) to put this then for the limited scenarios where it's possible, it would be nice for there to be a button to add this to the query automatically. Probably located next to the Edit Data button.
- I don't know if this is possible Oracle-wise in the first place, but it'd be great if it were possible to pause a program in debug mode after you've "let it go". I might start stepping through, and then hit the green triangle. After a few minutes of a large procedure I might wish to pause the code again (I might not be able to think of an elegant test scenario to break at, so the passing of time would be sufficient). A pause button would be handy if it's theoretically possible. Not sure if processing is essentially handed over to the db by then.
Many thanks.
