Answer Detail: RE: dear friendi want to know that in a t...

GeekInterview.com > Interview Questions > Oracle > General

Print |

Question: dear friend

i want to know that in a table how to change the column to row.

February 02, 2007 05:53:41	#4
ora.nachs	Member Since: January 2007 Total Comments: 9
RE: dear friendi want to know that in a t...
we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_id,week_id,sales_WED)INTO sales_info VALUES (employee_id,week_id,sales_THUR)INTO sales_info VALUES (employee_id,week_id, sales_FRI)SELECT EMPLOYEE_ID, week_id, sales_MON, sales_TUE,sales_WED, sales_THUR,sales_FRIFROM sales_source_data;this is exactly called as pivoting insert