Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Can we insert data into a particular row

    Can we insert data into a particular row using rownumber? If yes, can someone tell me how to insert.
    Thankyou

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    You can insert data into a particular row using the primary key of the table. If your table doesn't have a primary key, look for some other Unique values. Still if you are not able to find any of such, use the ROWID. Don't use ROWNUM ,because it keeps on changing.
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    Thankyou for your help. can you please give me an example(syntax).


    Originally posted by satish_ct
    HI,

    You can insert data into a particular row using the primary key of the table. If your table doesn't have a primary key, look for some other Unique values. Still if you are not able to find any of such, use the ROWID. Don't use ROWNUM ,because it keeps on changing.

Posting Permissions

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