Oracle UNPIVOT

Показать описание

How to use unpivot in SQL?

This video talks about usage of UNPIVOT in sql.

--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

--------------------------------------------------------------

Рекомендации по теме

Комментарии

Thanks Siva.. This helped me a lot today to solve my requirement. 👍👍

dalgandori

Thanks for the video, very well explained. Useful feature in Oracle.. you have explained it with short and easy simple example. 😇👍👍

amitlondhe

Hi Shiva, Nice explanation for understanding the concept with examples.
I have one doubt on transposing the data column to rows, In the above example you converted rows as columns.
My requirement is coverting columns into rows. Example: Col1 having the data 1, 2, 3, 4, 5 and Col2 having A, B, C, D, E
I want to show the data as first row should be Col1 | 1 | 2 | 3 | 4 | 5 and 2nd row should be Col2 | A | B | C | D | E

kranthikumar

How to pivot a row word 'oracle'as column can anyone write syntax

gashok

how do process list of name using pivot ?

hemukarnik

Good afternoon,
how do I make this dynamic unpivot, that is:

SELECTcol1, col2, col3
FROM tab_1
UNPIVOT (value
FOR value_col IN (Tab_colunas_unpivot)
)
)

Tab_colunas_unpivot = SELECT column_name FROM tab_2

gtgustavotiago