nth_value

Used to show specific row data as column.

Example:

PRODUCT_PRICE:

select distinct nth_value(ISEMRI_ABONE_ID, 4) over() as ISEMRI_ABONE_ID4,

nth_value(ISEMRI_ABONE_ID, 5) over() as ISEMRI_ABONE_ID5 from PRODUCT_PRICE