SQL Query Help

User_BU3NG

@Need a help in writing oracle query

I have a table Test with following information

DIM1	DIM2	DIM3	DIM4	DIM5	DIM6	SM1	SM2	SM3	SM4	SM5	SM6
A	B	C	D	E	F	1	2	3	4	5	6
A	B	C	D	E	F	2	2	2	2	2	2

I would need data with sum row wise, I wrote this query it works.

select DIM1, DIM2,DIM3,DIM4,DIM5,DIM6,(SM1+SM2+SM3+SM4+SM5+SM6) from  Test

But my requirement in table columns might increase, hence I would need this query to be dynamic, it should work though any additions or deletions in columns with out changing query.We are using Oracle 11g.

Thanks in advance.

Jagadekara

Hi,

You don't know how many columns, so you must use all_tab_cols table to bring cols dynamically.

you may need like this...

select column_name from all_tab_cols where table_name='YOUR_TABLE_NAME' and data_type='NUMBER', so it will display all columns with number data type.

Note that, it may not be the correct answer, but it may help you to give at least an idea.