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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. oralearner

    Does Table storage settings affect performance

    Any pointers to look around for a different cause ?
  2. oralearner

    Does Table storage settings affect performance

    Hi, I have a stored procedure that loads 300,000 rows in table1. The loading logic is 1)insert all 300,000 rows (first 10 columns only) 2)commit 3)perform some lookups and update remaining 5 columns using BULK features. I run the same procedure on two different tables on different schemas (on...
  3. oralearner

    Rowid in Index organized tables

    Oracle 8i complete reference says "rows of the index organized tables do not have rowIDs. So, it is not possible to select rowid pseudo column from an IOT." Here is what i tried.. create table test(c1 number primary key, c2 number) organization index; Table created. insert into...
  4. oralearner

    Doubt on Strings of Zero Length in oracle

    Oracle 816 Documentation states: "Strings of Zero Length Are Not Equivalent To a NULL A string of zero length ('') is not equivalent to a NULL. According to the ANSI SQL 1992 Transitional standard, a zero-length or empty string is not the same as NULL. The Oracle database server may...

Part and Inventory Search

Back
Top