Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
Line 12: Line 12:
<source lang="sql">
<source lang="sql">
SELECT
SELECT
     interpreted_code,
     translated_code,
     referred_table_name,
     translated_table_name,
     referred_field_value,
     translated_field_code,
     iso_alpha2_lingo_code,
     iso_alpha2_lingo_code,
     iso_alpha2_state_code,
     iso_alpha2_state_code,
     interpreted,
     translated,
     entered,
     entered,
     enterer,
     enterer,
Line 23: Line 23:
     amender
     amender
FROM
FROM
     interpreter
     translator
</source>
</source>

Revision as of 18:41, 11 September 2019

Translate

CREATE TABLE T01001 (
    code                    NUMBER(10) NOT NULL,
    entered                 DATE NOT NULL,
    enterer                 NUMBER(10) NOT NULL,
    amended                 DATE,
    amender                 NUMBER(10)
);
SELECT
    translated_code,
    translated_table_name,
    translated_field_code,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated,
    entered,
    enterer,
    amended,
    amender
FROM
    translator