Помогите с запросом!!!
как такой запрос будет выглядеть в Cache?

CREATE OR REPLACE VIEW V_HOUSE
(KEY, HOUSE_NUMBER, HOUSE_LITER, HOUSE_REST_NUMBER, HOUSE_REST_LITER,
HOUSE_BUILDING_NUMBER, HOUSE_BUILDING_LITER, CONSTRUCTION_NUMBER, CONSTRUCTION_LITER, DOMAIN_NUMBER,
DOMAIN_LITER, HOUSE_REST, HOUSE)
AS
SELECT
S_HOUSE.KEY,
S_HOUSE.HOUSE_NUMBER,
S_HOUSE.HOUSE_LITER,
S_HOUSE.HOUSE_REST_NUMBER,
S_HOUSE.HOUSE_REST_LITER,
S_HOUSE.HOUSE_BUILDING_NUMBER, -- корпус
S_HOUSE.HOUSE_BUILDING_LITER,
S_HOUSE.CONSTRUCTION_NUMBER, -- строение
S_HOUSE.CONSTRUCTION_LITER,
S_HOUSE.DOMAIN_NUMBER, -- владение
S_HOUSE.DOMAIN_LITER,
S_HOUSE.HOUSE_REST,
S_HOUSE.HOUSE_NUMBER||LTRIM(S_HOUSE.HOUSE_LITER)||
-- DECODE(S_HOUSE.HOUSE_REST_NUMBER,NULL,'',0,'','/')||
DECODE(S_HOUSE.HOUSE_REST_NUMBER,NULL,'','/')||
LTRIM(TO_CHAR(S_HOUSE.HOUSE_REST_NUMBER,'999'))||LTRIM(S_HOUSE.HOUSE_REST_LITER)||
DECODE(HOUSE_BUILDING_NUMBER,NULL,'',' К. '||to_char(HOUSE_BUILDING_NUMBER)||rtrim(HOUSE_BUILDING_LITER))||
DECODE(CONSTRUCTION_NUMBER,NULL,'',' СТР. '||to_char(CONSTRUCTION_NUMBER)||rtrim(CONSTRUCTION_LITER)||
DECODE(DOMAIN_NUMBER,NULL,'',' ВЛ. '||to_char(DOMAIN_NUMBER)||rtrim(DOMAIN_LITER))) as house
FROM
S_HOUSE