Is there any update on this topic?
Just evaluate PL/SQL-Dev for usage in our company and encountered this issue too. I really like the PL/SQL-Developer, but missing integration with VSS is definetly a No-Go-Criteria for us. It's not a practical way to open another version control project...
Since we moved to Oralce 9.2.0.5, we get the "ORA-01041: internal error. hostdef extension doesn't exist." error message, when we try to view or edit a table.
If we do the same stuff within the command line window, then it works without an error
System:
Oralce: 9.2.0.5
OS: SuSE SLES8...
CTX indexes were shown in the object tree (Tabeles -> Indexes), but not on the tabpage indexes in the EDIT/VIEW-TABLE-WINDOW.
The columns of the CTX-index weren't shown at all.
Stefan
Hello,
I would wish the possibility of simply renaming a table column within the edit window.
Since Oracle 9.x it's possible to rename a column.
ALTER TABLE tab_name RENAME COLUMN old_name TO new_name;
Yet, the column is dropped and added again afterwards. This works for empty tables, but...
Example
Master table (DEPARTMENT):
ID DEPT_NAME
CO Controlling
IS Information Systems
SU Support
Detail table (EMPLOYEES)
ID NAME DEPT_ID
001 Stefan IS
002 Marco SU
003 Ralf CO
004 Berit IS
Now, it's possible to export all master-detail-entries by selecting both tabels in the...
It would be nice to specify a WHERE-Clause when Selecting more than 1 table to export (master-detail-tables).
Something like
TABLE_NAME.FIELD_NAME = VALUE
At the moment you only get an error message like:
ORA-00904: "TABLE_NAME"."FIELD_NAME": invalid identifier.
Stefan