Retour
-
Titre
First letter of data is missing when viewed in a Nested Table -
Description
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
===========
Connexion requise
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.