Re: cursor

From: Hans-Gerd Sandhagen <Hans-Gerd.Sandhagen_at_ginko.de>
Date: Sat, 25 May 2002 13:03:53 +0200
Message-ID: <3CEF6F99.70406_at_ginko.de>


Hi,

what you want to count? The columns or the rows in a table.

If you want to count the rows in a table use "select count(*) from <table>".

If you want to know, how much columns are in a table you can ask the data dictionary:

select count(*)

   from USER_TAB_COLUMNS
  where Table_Name = '<YourTable>';

Hans-Gerd Sandhagen

s Lehaire wrote:

> HI,
> I would Like to know how to count my colums with a cursor.
> Or how can I count the number of rows into a table?
>
>
>
  Received on Sat May 25 2002 - 13:03:53 CEST

Original text of this message