Re: cursor

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?

Count the columns? If you wrote the SELECT statement you know unless you wrote SELECT *.

If you wrote SELECT * you could query the number of rows in xxx_TAB_COLUMNS with the correct owner and table_name.

The number of row?

Look it up at: http://otn.oracle.com/doc/server.815/a67842/11_elems.htm

And, in the future, make your first stop at http://technet.oracle.com

Daniel Morgan Received on Wed May 22 2002 - 10:17:21 CDT