how to limit number of records shown in SQL*PLUS?

From: Bomb Diggy <techguy_chicago_at_yahoo.com>
Date: 18 Jun 2003 09:40:42 -0700
Message-ID: <94599bb3.0306180840.4dd66203_at_posting.google.com>

Hi,

[Quoted] [Quoted] I thought Oracle has a SQL*PLUS command 'set rowcount 10' or similar. Is that only M$ SQL Server?

I don't need a 'top' anything, but if I select a bazillion records on accident, I want to see only the first 10.

Thanks. Received on Wed Jun 18 2003 - 18:40:42 CEST

This message: [ Message body ]
Next message: friedrich: "Re: Uploading file"
Previous message: Jane O: "Re: J2SDK no longer functions after Oracle installation"
Next in thread: Sybrand Bakker: "Re: how to limit number of records shown in SQL*PLUS?"
Reply: Sybrand Bakker: "Re: how to limit number of records shown in SQL*PLUS?"
Reply: Brian Peasland: "Re: how to limit number of records shown in SQL*PLUS?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message