User Profile

Collapse

Profile Sidebar

Collapse
MihirShah
MihirShah
Last Activity: Mar 13 '07, 01:12 PM
Joined: Jan 31 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MihirShah
    started a topic Sqlloader
    in Oracle

    Sqlloader

    I have a table with timestamp(3) field and I want to use sqlloader to insert rows into this table from an ascii file. Anyone has done this ?
    See more | Go to post
    • MihirShah
      replied to inserts and select
      in Oracle
      thanks for your reply. That's exactly what I want to find out under what circumstances will this happen ? If I am inserting let's say 1000 rows in one transaction, under what circumstances will the ROWIDs will not be in sync with the insert order ?...
      See more | Go to post

        Leave a comment:

      • MihirShah
        started a topic inserts and select
        in Oracle

        inserts and select

        If I insert rows in a table with no index, is select guaranteed to return the rows in the order it was inserted.
        Note: I am not doing any updates, deletes - pure inserts.
        In my small test that I did, it always retrieves in the order I inserted. But not sure if there are any case where it can retrieve in a different order.
        See more | Go to post
        No activity results to display
        Show More
        Working...