SQL Developer - Selects
- From: "markus.schreyer@xxxxxxxxx" <markus.schreyer@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 09:20:29 -0000
Hi together,
some questions about SQL Developer and how it is working with the
database...
When I open a datatable (tab data), SQLD does a coresponding select on
the table. Looking at enterprise manager i see that the select
consists out of ORA_ROWSCN and all the columns from the table. In a
table with million records i get an instant result cause only 55 rows
in my case are fetched. When i take the same select and execute it,
it would take much longer cause i get the whole table. How is it
possible to limit the number of records in the result with such a
select?
Is the result from such a select from the same point of time?
When i change sorting SQLD makes a new select statement.
Another question little bit offtopic is it possible to see a live
trace of a oracle session for example like tail, all the statements
from one session live?
Thanks for your time.. :)
Markus
.
- Follow-Ups:
- Re: SQL Developer - Selects
- From: Thomas Kellerer
- Re: SQL Developer - Selects
- Prev by Date: Re: Writing a file on a client pc
- Next by Date: Re: SQL Developer - Selects
- Previous by thread: Writing a file on a client pc
- Next by thread: Re: SQL Developer - Selects
- Index(es):