Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ragolia

  1. ragolia

    Can't load a CLOB into OracleXE using sql*loader

    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.
  2. ragolia

    Can't load a CLOB into OracleXE using sql*loader

    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)...
  3. ragolia

    null string problem

    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.
  4. ragolia

    null string problem

    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...
  5. ragolia

    null string problem

    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...
  6. ragolia

    Oracle 9i Performance on "Order By" clause

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

    null string problem

    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...
  8. ragolia

    Oracle 9i Performance on "Order By" clause

    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...
  9. ragolia

    null string problem

    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...
  10. ragolia

    null string problem

    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...
  11. ragolia

    Oracle 9i Performance on "Order By" clause

    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...
  12. ragolia

    Oracle 9i Performance on "Order By" clause

    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...
  13. ragolia

    Oracle 9i Performance on "Order By" clause

    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...
See more

Part and Inventory Search

Back
Top