quicksql icon indicating copy to clipboard operation
quicksql copied to clipboard

Identical insert statements

Open vadim-tropashko opened this issue 6 months ago • 0 comments

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'
);
...

vadim-tropashko avatar Jul 02 '25 15:07 vadim-tropashko