Oracle 11g added support for virtual columns. We need to enhance data studio to extract & script the virtual column information.
Will also need to modify the create/alter table GUI and add column property boolean <virtual>. The contents of the virtual column are maintained in the column default value. we should use the default value property to maintain the virtual column info.
WIll also need to modify ERM to support this property.
96 KB
Extraction and Scripting of virtual column information is complete. Beginning GUI modification work...
Virtual column property added to create/alter table GUIs. The virtual column details are held in the default value of the column. Once a column is created it may not be altered to/from a virtual column. The virtual column details default value are allowed to be modified for the virtual columns expression.
GUI modification and enhancements complete. Alter column scripts enhancement complete. Beginning work to ERM.
Virtual column property added to create/alter table GUIs. The virtual column details are held in the default value of the column. Once a column is created it may not be altered to/from a virtual column. The virtual column details default value are allowed to be modified for the virtual columns expression.
GUI modification and enhancements complete. Alter column scripts enhancement complete. Beginning work to ERM.
ERM enhancements complete. Will check code in for new build testing.
ERM enhancements complete. Will check code in for new build testing.
You should now be able to script the object correctly and added GUI support to create/alter table and ER modeler. Once testing is complete, code will be ported to v17 and trunk.
You should now be able to script the object correctly and added GUI support to create/alter table and ER modeler. Once testing is complete, code will be ported to v17 and trunk.
I am not able to create virtual columns using the Create Table GUI. Below scripts work in the Query Analyzer but I cannot create them using the GUI for Create table because the Virtual property is not enabled.
I am not able to create virtual columns using the Create Table GUI. Below scripts work in the Query Analyzer but I cannot create them using the GUI for Create table because the Virtual property is not enabled.
New columns are now allowed to get virtual property set.
New columns are now allowed to get virtual property set.
Create Table Extraction, Scripting, Schema Script Generator and ERM works fine. Alter virtual columns to modify properties work fine.
Alter a Table to add a new column with Virtual column does not work properly - there is issue in scripting.
To reproduce :
Create Table Extraction, Scripting, Schema Script Generator and ERM works fine. Alter virtual columns to modify properties work fine.
Alter a Table to add a new column with Virtual column does not work properly - there is issue in scripting.
To reproduce :
Script Columns -> Add column to table -> Support for virtual property scripting added.
Script Columns -> Add column to table -> Support for virtual property scripting added.
Issue #13928 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v16.0.10-6 |
No time estimate |
Extraction and Scripting of virtual column information is complete. Beginning GUI modification work...