Skip to content

Identical insert statements #78

@vadim-tropashko

Description

@vadim-tropashko
someone /insert 5
    name
    age int 
    address
    country

-- create tables

create table someone (
    id         number generated by default on null as identity
               constraint someone_id_pk primary key,
    name       varchar2(255 char),
    age        integer,
    address    varchar2(4000 char),
    country    varchar2(4000 char)
);



-- load data

insert into someone (
    id,
    name,
    age,
    address,
    country
) values (
    1,
    'Landon Glover',
    '38',
    '837 Wubju Drive',
    'ID'
);
insert into someone (
    id,
    name,
    age,
    address,
    country
) values (
    2,
    'Landon Glover',
    '38',
    '837 Wubju Drive',
    'ID'
);
...

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions