Recent content by Mozart

  1. M

    Editable View

    Is any possibility how to edit view with "INSTEAD OF" trigger. When i try it (on some more complex view) i always get ORA-01446 error. Thanks for any hints.
  2. M

    Compile invalid objects

    Oh yes. This was right. I didnt know, that default filter changed (i didn't knew, that there was any filter). After changing it to Complie invalid objects works well. Thanks for help.
  3. M

    Compile invalid objects

    I have a problem in new version (8.0.0.1480) of PL/SQL Developer with Compile Invalid Objects tool. It shows no invalid objects. In version before (7.1.5.1398) invalid objects was shown correctly. Can anyone help me with this problem? I dont want to have installed both versions just because of...
  4. M

    Deleting columns from table

    When i delete column from table, related script is generated badly. Example: When i delete column X from table SCH_ADDRESS.TBL_POST -- Drop columns alter table SCH_ADDRESS.TBL_POST drop column X; -- Create/Recreate primary, unique and foreign key constraints alter table SCH_ADDRESS.TBL_POST...
See more
Back
Top