Insert Command

Insert

Adds new rows to a table, can include subquery to copy rows from an existing table

INSERT INTO accountmanager
VALUES ('T500', 'NICK', 'TAYLOR', '05-SEP-09', 4200, 3500, 'NE');
 Insert With column Names Null values at the end.

INSERT INTO acctmanager(amid, amfirst, amlast, amedate, amsal, acomm)
VALUES ('T500', 'NICK', 'TAYLOR', '05-SEP-09', 4200, 3500, );

INSERT INTO acctmanager(amid, amfirst, amlast, amedate, amsal, acomm)
VALUES ('T500', 'NICK', 'TAYLOR', '05-SEP-09', 4200, 3500, NULL);

Use System date as an entry

insert into acctmanager(amid, amfirst, amlast, amedate, amsal, amcoMm, region)
values ('R500', 'ROBERT', 'JONES', SYSDATE, 50000, 1000, 'NW')

Add Virtual Column

ALTER TABLE acctmanager
ADD (amearn AS (amsal + amcomm));

Add name with an apostrophe - Use two single quotes

insert into acctmanager(amid, amfirst, amlast, amedate, amsal, amcoMm, region)
values ('R500', 'ROBERT', 'OHARA', SYSDATE, 50000, 1000, 'NW')

Inserting data from an existing table using a subquery

INSERT INTO acctbonus (amid, amsal, region)
SELECT amid, amsal, region
FROM acctmanager;

Back To Top- Home - Category