|
From: <co...@in...> - 2004-07-01 22:59:20
|
Hi Ethan, Works for me Oracle: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production JDBC thin driver: 9.2.0.3.0 java: 1.4.2_03-b02 If its working in the Content Tab but not in the SQL tab then it may be something as simple as you having the "Contents - Limit Rows" checkbox selected with a small number of rows (e.g. 100) in the Object Tree tab in your session properties but not having the "Limit Rows" checkbox selected on the SQL tab, which could mean (depending on the size of your table) that you are bringing back a large amount of data which may take a long time. Are you using an ORDER BY clause or a WHERE clause that may be causing a full table scan and so slowing it down? Col > Does anyone know why a SQL statement that selects a table > that contains a CLOB column is causing my SQuirrel Client > to lockup? I can view the same table in Object Tree with > no problems. > > SQuirrel Version: 1.2beta6 > Java Version: 1.4.2_04 > Database: Oracle 9.2.0.4 > > CLOB column metadata: > COLUMN_NAME: ENTRY > TYPE_NAME: CLOB > COLUMN_SIZE: 4000 > DECIMAL_DIGITS: <null> > IS_NULLABLE: YES > COLUMN_DEF: <null> > REMARKS: <null> > DATA_TYPE: 1111 > BUFFER_LENGTH: 0 > NUM_PREC_RADIX: 10 > NULLABLE: 1 > SQL_DATA_TYPE: 0 > SQL_DATETIME_SUB: 0 > CHAR_OCTET_LENGTH: 4000 > ORDINAL_POSITION: 5 |
