Servus,
we use PL/SQL Developer Version 13.0.6.1911.
We found unwonted Edits on Indexes.
1. open a Table to edit Table
2. Klick on definded Index on the tree point button
3. the edit dialog is opend and display as one line now lower
4. do Nothing and close with OK!
in the background still waitung a ddl with the lower Values
Problem: if a made additional real changes and press apply and do not take a look in the real DDL - my function based index ist wrong - in my case it was a unique index that goes wrong
Yours Daniel
/update - images
we use PL/SQL Developer Version 13.0.6.1911.
We found unwonted Edits on Indexes.
1. open a Table to edit Table

Code:
.. RKOMP_ID, RMEA_ID, REIHT_ID, RME_ID, DECODE(DEFAULT_JN,'J','J',TO_CHAR(ID)) ..
2. Klick on definded Index on the tree point button

3. the edit dialog is opend and display as one line now lower
Code:
DECODE(DEFAULT_JN,'j','j',TO_CHAR(ID))
4. do Nothing and close with OK!
in the background still waitung a ddl with the lower Values
Code:
drop index..
create index .. RKOMP_ID, RMEA_ID, REIHT_ID, RME_ID, DECODE(DEFAULT_JN,'j','j',TO_CHAR(ID)) ..

Problem: if a made additional real changes and press apply and do not take a look in the real DDL - my function based index ist wrong - in my case it was a unique index that goes wrong

Yours Daniel
/update - images
Last edited: