select "CODE_WARES","CODE_GROUP","NAME_WARES","PRICE","CODE_WARES_DUP","CODE_GROUP_DUP","NAME_WARES_DUP","PRICE_DUP","COUNT_DIF"
from TABLE(CAST(POSS_DUP as TA_POSS_DUP)) t
order by count_dif desc

где

POSS_DUP TA_POSS_DUP:=TA_POSS_DUP(TPOSS_DUP(null,null,null,null,null,null,null,null,null));

create or replace type TA_POSS_DUP is table of TPOSS_DUP;

create or replace type TPOSS_DUP as object
(
-- Author : EARL
-- Created : 01.11.2002 14:56:03
-- Purpose :
-- Attributes
CODE_WARES NUMBER,
CODE_GROUP NUMBER,
NAME_WARES VARCHAR2(100),
PRICE NUMBER,

CODE_WARES_DUP NUMBER,
CODE_GROUP_DUP NUMBER,
NAME_WARES_DUP VARCHAR2(100),
PRICE_DUP NUMBER,

COUNT_DIF number(4) );