Results 1 to 3 of 3

Thread: insert rows

  1. #1
    Join Date
    Feb 2004
    Posts
    19

    Unanswered: insert rows

    i would like to insert a row between two rows in a table.how should i do it

    thanks
    kk

  2. #2
    Join Date
    Jan 2004
    Location
    North Haven, CT
    Posts
    110

    Re: insert rows

    Originally posted by madala99
    i would like to insert a row between two rows in a table.how should i do it

    thanks
    kk
    There is no order of records in oracle tables, unless you select and order by, explicitly ordering the result set.

  3. #3
    Join Date
    Jan 2004
    Posts
    492

    Re: insert rows

    Originally posted by madala99
    i would like to insert a row between two rows in a table.how should i do it

    thanks
    kk

    This cannot be done, and it really wont serve much of a purpose. If you are worried about rows showing up in order, then use an ORDER BY clause. When Oracle queries the database, it pulls back the rows arbitrarily anyway. There is no guarantee it would pull them back in order.

    Mind if I ask why exactly you want to do this? I have a feeling you'll say b/c you are using a GUI tool and the data looks out of place.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •