-
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...
-
set linesize 10000;
in sqlplus
-
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
-
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.
-
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.
-
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
-
Script, or use a database tool like toad or plsqldeveloper.
-
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|