Скрипт cr_v.sql

-- *********************************************************************
-- Name: cr_v.sql
-- Purpose:
-- Author: Vladimir Begun
-- $Id$
-- TODO: XXX

PROMPT Various views creation...
SET FEEDBACK OFF

CREATE OR REPLACE VIEW viw$payment_russian
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_russian
AND fkey_category = &category_payment
/

CREATE OR REPLACE VIEW viw$payment_english
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_english
AND fkey_category = &category_payment
/

CREATE OR REPLACE VIEW viw$payment_german
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_german
AND fkey_category = &category_payment
/

CREATE OR REPLACE VIEW viw$currency_russian
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_russian
AND fkey_category = &category_currency
/

CREATE OR REPLACE VIEW viw$currency_english
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_english
AND fkey_category = &category_currency
/

CREATE OR REPLACE VIEW viw$sex_russian
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_russian
AND fkey_category = &category_sex
/

CREATE OR REPLACE VIEW viw$sex_english
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_english
AND fkey_category = &category_sex
/

CREATE OR REPLACE VIEW viw$sex_german
AS
SELECT fkey_lookup
, name
FROM code_name
WHERE fkey_language = &l_german
AND fkey_category = &category_sex
/
SET FEEDBACK ON