Re: cursor
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 22 May 2002 15:17:21 GMT
Message-ID: <3CEBB674.4F515979_at_exesolutions.com>
Date: Wed, 22 May 2002 15:17:21 GMT
Message-ID: <3CEBB674.4F515979_at_exesolutions.com>
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 - 17:17:21 CEST