Insert Command - Revision history

Bacchas at 16:59, 27 October 2017

2017-10-27T16:59:42Z

@@ Line 25: / Line 25: @@
   SELECT amid, amsal, region
   FROM acctmanager;
 [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

2017-10-18T13:27:23Z

← Older revision		Revision as of 13:27, 18 October 2017
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]]

2017-10-18T01:19:04Z

← Older revision		Revision as of 01:19, 18 October 2017
Line 22:		Line 22:

	=== Inserting data from an existing table using a subquery ===		=== Inserting data from an existing table using a subquery ===
			INSERT INTO acctbonus (amid, amsal, region)
			SELECT amid, amsal, region
			FROM acctmanager;

2017-10-18T01:14:22Z

← Older revision		Revision as of 01:14, 18 October 2017
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 ~~'''~~		''' Insert With column Names Null values at the end.'''
	Null values at the end.
	INSERT INTO acctmanager(amid, amfirst, amlast, amedate, amsal, acomm)		INSERT INTO acctmanager(amid, amfirst, amlast, amedate, amsal, acomm)
	VALUES ('T500', 'NICK', 'TAYLOR', '05-SEP-09', 4200, 3500, '');		VALUES ('T500', 'NICK', 'TAYLOR', '05-SEP-09', 4200, 3500, '');
Line 13:		Line 13:
	insert into acctmanager(amid, amfirst, amlast, amedate, amsal, amcoMm, region)		insert into acctmanager(amid, amfirst, amlast, amedate, amsal, amcoMm, region)
	values ('R500', 'ROBERT', 'JONES', SYSDATE, 50000, 1000, 'NW')		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', 'O''HARA', SYSDATE, 50000, 1000, 'NW')

			=== Inserting data from an existing table using a subquery ===

2017-10-18T00:59:45Z

← Older revision		Revision as of 00:59, 18 October 2017
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')

2017-10-17T00:43:06Z

← Older revision		Revision as of 00:43, 17 October 2017
Line 1:		Line 1:
	=Insert =		=Insert =
	''' Adds new rows to a table, can include subquery to copy rows from an existing table '''		''' 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');

2017-10-17T00:03:04Z

Created page with "=Insert = ''' Adds new rows to a table, can include subquery to copy rows from an existing table '''"

New page

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