|
|
|
|
|
|
|
Re: sys to see alert log.... [message #527784 is a reply to message #527756] |
Thu, 20 October 2011 03:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
hi,
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
|
|
|
|
|
|
Re: sys to see alert log.... [message #527793 is a reply to message #527786] |
Thu, 20 October 2011 03:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Michel Cadot wrote on Thu, 20 October 2011 03:20count(*) count(*) count(*) count(*) count(*) count(*) count(*) count(*) count(*)
How many will we have to repeat it?
Regards
Michel
hi,
Can you get a right way to get the last 100 rows of a table?
|
|
|
Re: sys to see alert log.... [message #527794 is a reply to message #527793] |
Thu, 20 October 2011 04:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
There is a way - you should only know the rule which sorts these rows. For example, it might be a sequence, a timestamp or something similar. If there's no way to distinguish the sort order, then "the last 100 rows" is meaningless.
|
|
|