OraFAQ Forum: Forms » count the number of column

Home » Developer & Programmer » Forms » count the number of column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

count the number of column [message #271854]

Wed, 03 October 2007 03:00

ramaro
Messages: 2
Registered: May 2007
Location: MADAGASCAR-Antananarivo

Junior Member

Hi all,
I work with forms 6i and database oracle 8. I want to know if it's possible to count the number of column in a sql query. For exemple, i have : "select id, name, dtbirth from table". In this query, I have 3 column. But I don't know how can I get it! Someone can help me! please!

best regards.

Report message to a moderator

Re: count the number of column [message #271856 is a reply to message #271854]

Wed, 03 October 2007 03:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Count number of commas + 1 between SELECT and FROM.

What do you plan to do with this information?

Report message to a moderator

Re: count the number of column [message #271864 is a reply to message #271856]

Wed, 03 October 2007 03:45

ramaro
Messages: 2
Registered: May 2007
Location: MADAGASCAR-Antananarivo

Junior Member

Thank's for your help. I can't do this because my select is in a cursor.

I fetch data in a loop. And in this loop, i create an another loop for affectation. I want to do this :
........
for c1 in cur_ex loop
while i<nbr_col
dbms_output.put_line('column['||i||']=' ||c1(i));
i:=i+1;
end;
........
for exemple.

end loop;

Report message to a moderator

Re: count the number of column [message #271874 is a reply to message #271864]

Wed, 03 October 2007 04:25

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Who wrote this cursor? You? If so, number of columns is not unknown.

What is "c1(i)" supposed to do? Such a syntax is invalid (unless there's a function named c1, but - regarding the context - I'd say that you are talking about a cursor variable).

Finally, what are you trying to do? What should be the result of this operation?

Report message to a moderator

Re: count the number of column [message #272116 is a reply to message #271874]

Thu, 04 October 2007 01:27

anisam10674
Messages: 18
Registered: March 2007

Junior Member

As far as number of columns of a table is concerned we can use the following query...

SELECT COUNT(column_name) FROM all_tab_columns WHERE table_name =<table_name>

Maybe some logical inclusions in the above query can solve your purpose

Report message to a moderator

Re: count the number of column [message #272440 is a reply to message #272116]

Fri, 05 October 2007 01:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

For crying out loud, WHAT ARE YOU TRYING TO DO?

David

Report message to a moderator

Previous Topic:	frm-41214: unable to run report
Next Topic:	Tiny_Oracle Arrives !!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 14:19:49 CDT 2025