Update Command - Revision history

Bacchas at 19:59, 18 October 2017

2017-10-18T19:59:17Z

← Older revision		Revision as of 19:59, 18 October 2017
Line 28:		Line 28:
	WHERE state ='&State';		WHERE state ='&State';

			''' This will pop up a dialog box prompting you to enter the Region and State'''

	~~''' This will pop up a dialog box prompting you to enter the Region and State'''~~
	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 19:57, 18 October 2017

2017-10-18T19:57:49Z

← Older revision		Revision as of 19:57, 18 October 2017
Line 24:		Line 24:
	'''A substitution variable in an SQL command instructs Oracle 11g to substitute a value in place of the variable at the time the command is actually executed. To include a substitution variable in an SQL command, simply enter an ampersand (&) followed by the name used for the variable.'''		'''A substitution variable in an SQL command instructs Oracle 11g to substitute a value in place of the variable at the time the command is actually executed. To include a substitution variable in an SQL command, simply enter an ampersand (&) followed by the name used for the variable.'''

			UPDATE customers
			SET region = '&Region'
			WHERE state ='&State';


			''' This will pop up a dialog box prompting you to enter the Region and State'''
	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 13:59, 18 October 2017

2017-10-18T13:59:55Z

← Older revision		Revision as of 13:59, 18 October 2017
Line 14:		Line 14:
	SET region = 'W'		SET region = 'W'
	WHERE region IN ('NE', 'NW')		WHERE region IN ('NE', 'NW')

			== Update Multiple Columns ===
			UPDATE acctmanager
			SET amedate = '10-OCT-09',
			region = 'S'
			WHERE amid = 'J500'

			== Using Substituion Variables ==
			'''A substitution variable in an SQL command instructs Oracle 11g to substitute a value in place of the variable at the time the command is actually executed. To include a substitution variable in an SQL command, simply enter an ampersand (&) followed by the name used for the variable.'''


	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 13:44, 18 October 2017

2017-10-18T13:44:50Z

← Older revision		Revision as of 13:44, 18 October 2017
Line 2:		Line 2:
	''' Used to change the contents of existing rows '''		''' Used to change the contents of existing rows '''
	* The UPDATE clause identifies the table containing the records to be changed.		* The UPDATE clause identifies the table containing the records to be changed.
	* The SET clause identifies the columns to be changed and the new values to		* The SET clause identifies the columns to be changed and the new values to be assigned to these columns.
	be assigned to these columns.		* The optional WHERE clause identifies the exact records to be changed by the UPDATE command. If the WHERE clause is omitted, the column specified in the SET clause is updated for all records in the table.
	* The optional WHERE clause identifies the exact records to be changed by the
	UPDATE command. If the WHERE clause is omitted, the column specified in		UPDATE acctmanager
	the SET clause is updated for all records in the table.		SET amedate = '01-AUG-09'
			WHERE amid = 'J500';

			== Change multiple records that match a criteria ==
			''' All records that have NE and NW will be changed to W'''
			UPDATE acctmanager
			SET region = 'W'
			WHERE region IN ('NE', 'NW')


	[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: Created page with "= Update Command = ''' Used to change the contents of existing rows ''' * The UPDATE clause identifies the table containing the records to be changed. * The SET clause ident..."

2017-10-18T13:30:56Z

Created page with "= Update Command = ''' Used to change the contents of existing rows ''' * The UPDATE clause identifies the table containing the records to be changed. * The SET clause ident..."

New page

= Update Command =
''' Used to change the contents of existing rows '''
* The UPDATE clause identifies the table containing the records to be changed.
* The SET clause identifies the columns to be changed and the new values to
be assigned to these columns.
* The optional WHERE clause identifies the exact records to be changed by the
UPDATE command. If the WHERE clause is omitted, the column specified in
the SET clause is updated for all records in the table.

[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]