OraFAQ Forum: SQL & PL/SQL » Getting Columns Selected Via A Query Dynamically

Home » SQL & PL/SQL » SQL & PL/SQL » Getting Columns Selected Via A Query Dynamically (Oracle9i,9.2.0.6.0,Windows XP)

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

Getting Columns Selected Via A Query Dynamically [message #310947]

Wed, 02 April 2008 23:21

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

Dear All,

Is their any way to get the number of columns selected via a sql query dynamically.

For Example:-

If i have a select query which select 200 columns from a table.
Is their any way to get number 200 i.e no of columns selected in SQL query dynamically.

select count(1) from (<query which select 200 columns from a table>)

That will result 200

Regards,
Rajat Ratewal

Report message to a moderator

Re: Getting Columns Selected Via A Query Dynamically [message #310973 is a reply to message #310947]

Thu, 03 April 2008 00:17

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not directly in SQL.
You have to use dbms_sql to parse your statement and then the number of columns from it.

Regards
Michel

[Updated on: Thu, 03 April 2008 00:18]

Report message to a moderator

Re: Getting Columns Selected Via A Query Dynamically [message #311081 is a reply to message #310973]

Thu, 03 April 2008 06:48

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

Dear Michel,

Can you please provide some example.

Cheers,
Rajat Ratewal

Report message to a moderator

Re: Getting Columns Selected Via A Query Dynamically [message #311083 is a reply to message #311081]

Thu, 03 April 2008 06:50

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

rajatratewal wrote on Thu, 03 April 2008 12:48

Dear Michel,

Can you please provide some example.

Cheers,
Rajat Ratewal

He did, read the link that he posted.

Report message to a moderator

Re: Getting Columns Selected Via A Query Dynamically [message #311103 is a reply to message #311083]

Thu, 03 April 2008 07:16

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

Thanks you very much I found the script in it.

Regards,
Rajat Ratewal

Report message to a moderator

Previous Topic:	performance in Context switch
Next Topic:	show sum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 01:47:38 CST 2025