Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: Oracle procedure

    Hi to all,

    I have one procedure in that procedure i am inserting data into temp table.
    Only through this channel only I am inserting data into temp table.
    Now I want to find the data in temp table session wise.

    Suppose if I inserted 10 records at this moment. I want to find only those 10 records. I don’t want to find previous records.
    Please let me know is there any way to find through session concept.
    How to find how many records are inserted/update/deleted in particular session.(particular moment).
    here there is no timestamp column in my table.

    regards
    jagan

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If the design of the table did not include a creation timestamp, then you are out of luck unless you are on oracle 10r2, If you are on oracle 10 then check out the following link.

    http://download-east.oracle.com/docs...7.htm#BABFAFIC

    The method is not exact and you should change your design to store a timestamp.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    you could use rowid if you knew the exact number of rows you inserted.
    as stated by Bill, you really need a created timestamp.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Global Temporary Table?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Anacedent has a good point. How are you using this temp table. Are you loading it for use by one session and then deleting the data or are you holding data across for use by different sessions.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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