Refresh data in OEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Refresh data in OEM

  1. #1
    Join Date
    May 2001
    Posts
    285

    Unhappy Refresh data in OEM

    Hi,

    I have a table with quite a few columns, so it's a pain to view its records from sql*plus, as the record will wrap around and you don't know what you are looking at. So from time to time, I use OEM's data editor which has a scrollable bar in the bottom to view the data in that table. However, I don't see a way to refresh data (in case new data being added after I opened that table editor). So in order to see new data, I have to close the data editor first, and then reopen it which is quite annoying.

    Anybody know how to refresh the returned data or any other workaround on this?

    TIA...

  2. #2
    Join Date
    Nov 2000
    Posts
    440
    set linesize 10000;

    in sqlplus

  3. #3
    Join Date
    May 2001
    Posts
    285
    Thanks, but this doesn't help in my case. The result is still a mess and hard to read.

    Originally posted by steeve123
    set linesize 10000;

    in sqlplus

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    Lest say table1 with column1 is like varchar2(2000)

    col format column1 format a10;

    Do this for column that is larger than supose to be.

  5. #5
    Join Date
    May 2001
    Posts
    285
    Yes, I did that already. But since there are 30+ columns in that table, and at least 2 fields are quite long, even after doing that, it still hard to read.

    Plus, how do I save all the set options so I can reuse it next time?

    Originally posted by steeve123
    Lest say table1 with column1 is like varchar2(2000)

    col format column1 format a10;

    Do this for column that is larger than supose to be.

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by elaine3839
    Plus, how do I save all the set options so I can reuse it next time?
    Script?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  7. #7
    Join Date
    Nov 2000
    Posts
    440
    Script, or use a database tool like toad or plsqldeveloper.

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Use the print_table script shown in this thread.

    http://www.dbasupport.com/forums/sho...ght=printtable
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

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



Click Here to Expand Forum to Full Width