SQL Navigator freezes when selecting tables with a large number of columns.
For example:
1. Create a table with over 300 fields with different datatypes and data in it.
CREATE TABLE AAANAV_TEST( FIELD1 NUMBER(10), FIELD2 NUMBER(25), FIELD3 NUMBER(22), FIELD4 NUMBER(22), FIELD5 NUMBER(14), FIELD6 DATE, FIELD7 VARCHAR2(15), ,.................................FIELD298 NUMBER(10), FIELD299 NUMBER(21,2), FIELD300 VARCHAR2(5);
2. Run a sample select statement, SQL Navigator freezes.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center