Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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 ===========
로그인 필요
프리미엄 기술 문서를 보려면 로그인해야 하며 최신 유지 관리 계약이 있어야 합니다.