Difference between revisions of "Insert Command"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
INSERT INTO accountmanager | INSERT INTO accountmanager | ||
VALUES ('T500', 'NICK', 'TAYLOR', '05-SEP-09', 4200, 3500, 'NE'); | 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') | |||
Revision as of 00:59, 18 October 2017
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')