Recent content by vc

IF you edit the spec and body of a package or type, and only change the body, why does to spec get re-compiled? This is mildly annoying with packages, but with object types (with dependents), you either have to open a new window to edit just the body, or open a command window and drop the type...

If you modify a type definition, the browser shows an entry for every modificaton. What is even worse, if you then try to view/edit the type, the source for ALL of the versions are interleaved and displayed in the edit window. Example: SQL> create type t_test as object (att1 number); Type...

If you edit a table, switch to the Keys tab, and change the name of a key, the ddl produced is: -- Drop primary, unique and foreign key constraints alter table CODES drop constraint SYS_C002429 cascade; -- Create/Recreate primary, unique and foreign key constraints alter table CODES add...