First letter of data is missing when viewed in a Nested Table
説明
The first letter of a row of data is not shown, when viewed inside a Nested Table in Toad.
To replicate this:
=========== 1. Create the following user Type and Table:
CREATE OR REPLACE TYPE test_vchar_99 AS TABLE OF VARCHAR2(99); CREATE TABLE TEST_VCHAR (NAME VARCHAR2(99), TEST_TAB test_vchar_99) NESTED TABLE TEST_TAB STORE AS TEST_VCHAR_VALUES;
2. Run one insert:
insert into TEST_VCHAR (name, test_tab) values('T1',test_vchar_99('LINE1','LINE2','LINE3')); commit;
When double-clicking the nested table field TEST_TAB in Schema Browser, you will see the wrong data is shown, as the first letter is missing ===========
対策
WORKAROUND: None.
STATUS: Waiting for fix in a future release of Toad for Oracle