Difference between revisions of "Insert Command"

From rbachwiki
Jump to navigation Jump to search
Line 25: Line 25:
  SELECT amid, amsal, region
  SELECT amid, amsal, region
  FROM acctmanager;
  FROM acctmanager;
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

Revision as of 13:27, 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')

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