-- -- Locale definitions in Oracle consist of a language, and optionally -- territory and character set. (Languages are associated with default -- territories and character sets when not defined). The formats -- for numbers, currency, dates, etc. are determined by the territory. -- CREATE TABLE cr_locales ( locale varchar(4) PRIMARY KEY NOT NULL, label varchar(200) NOT NULL, nls_language varchar(30) NOT NULL, nls_territory varchar(30), nls_charset varchar(30) ); CREATE UNIQUE INDEX cr_locale_name_unq ON cr_locales (label); CREATE TRIGGER RI_ConstraintTrigger_a_341367 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341368 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to cr_locales: --cr_items(cr_locale_abbrev_pk) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
