求教SQL, row 變column

hold_find

table 有如下
member, work

member

name	id
Peter	123
John	124
Tom	125

work

id	year	work
123	2015	Peter work 1
123	2016	Peter work 2
123	2017	Peter work 3
124	2015	John work 1
124	2016	John work 2

現在想output Peter和John的2016前首5工作記錄，按year倒序排

name	id	work1	work1 year	work2	work2 year	work3	work3 year	work4	work4 year	work5	work5 year
Peter	123	Peter work 2	2016	Peter work 1	2015	-	-	-	-	-	-
John	124	John work 2	2016	John work 1	2015	-	-	-	-	-	-

SQL可以怎樣寫?
DB是oracle不知怎樣可以row 變column地output出來...

thx

7h1r733n

https://blogs.oracle.com/sql/how ... a-pivot-and-unpivot