Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
Line 3: Line 3:
CREATE TABLE T01001 (
CREATE TABLE T01001 (
     code                    NUMBER(10) NOT NULL,
     code                    NUMBER(10) NOT NULL,
iso_alpha2_region_code                DATE NOT NULL,
     entered                DATE NOT NULL,
     entered                DATE NOT NULL,
     enterer                NUMBER(10) NOT NULL,
     enterer                NUMBER(10) NOT NULL,
Line 9: Line 8:
     amender                NUMBER(10)
     amender                NUMBER(10)
);
);
</source>
<source lang="sql">
SELECT
    interpreted_code,
    referred_table_name,
    referred_field_value,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    interpreted,
    entered,
    enterer,
    amended,
    amender
FROM
    interpreter
</source>
</source>

Revision as of 18:37, 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
    interpreted_code,
    referred_table_name,
    referred_field_value,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    interpreted,
    entered,
    enterer,
    amended,
    amender
FROM
    interpreter