Recent content by ragolia

Want to add one more point. Based upon posts in other forums, it is possible that OracleXE sets a 'default' LOB (CLOB, or BLOB) maximum size of 32k. Does anyone know how to change that default. It will not work for what I'm trying to do.

I'm using OracleXE (10g) and attempting to load a file into the table. The table is defined as follows: CREATE TABLE "ERROR_CODE_MASTER" ( "ERROR_CODE" VARCHAR2(255) NOT NULL ENABLE, "ERROR_SHORT_DESC" VARCHAR2(2000) NOT NULL ENABLE, "SEVERITY" VARCHAR2(255), "STATUS" VARCHAR2(255)...

The hint as posted by andyclap is I believe valid for any db when using VB as a front end. I have run into the need to use that same algorithm with VB as a front end to an Access DB (very small # of users) and SQL Server.

All I have to say this. Between the last few responses, it looks to me a little like this conversation has taken on deep philosophical connotations. All because Oracle syntax is constrained in such a way as to impose multiple interpretations of the same data (or lack thereof). Wow - that...

Ok, this is it before I walk away from here... What I was pointing out with my last is this... The row inserted by this insert INSERT INTO DEPT VALUES(13,'TEST5',''); is retrieved by this query SELECT * FROM DEPT WHERE LOC IS NULL; AND not retrieved by the query SELECT * FROM DEPT WHERE LOC...

Thank you all very much. Now I have work to do and all this has been very helpful.

Dave Actually Dave, I appreciate when people are willing to add to my headaches. Don't protect me from my screw-ups - I won't learn anything that way. You are correct in pointing out the error in my query - although I will plead some innocense or lack of typing ability. The query I actually...

Dima Now I'm really confused. Prior to your jumping in, and I appreciate that you did, the consensus seemed to be that the 'order by' caused at least some amount of overhead. If I read you correctly, with fld_a being the primary key and indexed, the use of the 'order by' will incur no...

Ok, I'm about to eat a little crow, I think. I ran these 3 sql updates as a test... (The dept table consists of 3 columns DEPTNO = NUMERIC PRIMARY KEY DNAME = VARCHAR2 LOC = VARCHAR2) INSERT INTO DEPT VALUES(14,'TEST6',CHR(0)); INSERT INTO DEPT VALUES(12,'TEST4',NULL); INSERT INTO DEPT...

A little heads up for everyone in this thread. Oracle does make a distinction between NULL and binary zeroes. It is possible to populate a field (particularly CHAR or VARCHAR)with binary zeroes and Oracle will not recognize that as NULL. This is contingent upon the appropriate setting of the...

A little application description here... There are about 160 tables that I have to apply this basic query to. In all cases, all of the columns are required to be part of the resultset. Some of these tables have as few as 10 columns. Others have as many as 200 columns. The database supports a...

Ok so let me try to 'draw a picture' here. The first read is against the index returning the row-ids of the rows required to satisfy the query. The second pass takes the results of the index check against the table itself returning the necessary rows from the table. Sorry if I'm...

I have what I feel is a really simple question about Oracle 9i and the performance of the "Order By" clause. I pose this question because my company DBA's are being rather dogmatic about their response. The situation that I have is this - I have a simple query with an order_by clause...