Message-ID: <3CEF6F01.9040107@ginko.de>
Date: Sat, 25 May 2002 13:01:21 +0200
From: Hans-Gerd Sandhagen <Hans-Gerd.Sandhagen@ginko.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
X-Accept-Language: de-DE, en, en-gb, en-us
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
To: s Lehaire <s.lehaire@meilleuregestion.com>
Subject: Re: cursor
References: <acfnoo$sjq$1@reader1.imaginet.fr>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.202.66.175
X-Original-NNTP-Posting-Host: 212.202.66.175
X-Trace: news.ginko.net 1022324484 212.202.66.175 (25 May 2002 13:01:24 +0200)
X-Original-Trace: 25 May 2002 13:01:24 +0200, 212.202.66.175
Lines: 27


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?
> 
> 
>