View - Revision history

Bacchas: /* CREATING A VIEW FROM MORE THAN ONE TABLE */

2017-11-14T16:03:09Z

CREATING A VIEW FROM MORE THAN ONE TABLE

← Older revision		Revision as of 16:03, 14 November 2017
Line 27:		Line 27:

	==CREATING A VIEW FROM MORE THAN ONE TABLE ==		==CREATING A VIEW FROM MORE THAN ONE TABLE ==
			CREATE VIEW SALES_SOUTH AS
			SELECT S.SALES_DATE, S.ORDER_ID, S.PRODUCT_ID, C.REGION
			FROM SALES S, CUSTOMER C
			WHERE S.CUSTOMER_ID = C.CUSTOMER_ID
			AND C.REGION = 'SOUTH';

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

2017-11-14T16:01:53Z

← Older revision		Revision as of 16:01, 14 November 2017
Line 26:		Line 26:
	WHERE customer_id = 10;		WHERE customer_id = 10;

			==CREATING A VIEW FROM MORE THAN ONE TABLE ==


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

2017-11-14T15:40:01Z

UPDATING THE VIEW

← Older revision		Revision as of 15:40, 14 November 2017
Line 21:		Line 21:

	==UPDATING THE VIEW==		==UPDATING THE VIEW==
			Updating records in a view will update the underlying table
			UPDATE customer_south
			SET address_line1 = "1123 Main street"
			WHERE customer_id = 10;



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

2017-11-14T15:12:15Z

← Older revision		Revision as of 15:12, 14 November 2017
Line 19:		Line 19:
	FROM customer		FROM customer
	WHERE lower(region) = 'south'		WHERE lower(region) = 'south'

			==UPDATING THE VIEW==



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

2017-11-14T15:08:48Z

@@ Line 8: / Line 8: @@
   FROM customer
   WHERE lower(region) = 'south'
 [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

2017-11-14T14:51:19Z

← Older revision		Revision as of 14:51, 14 November 2017
Line 4:		Line 4:
	** Only definition (query) of the view is stored		** Only definition (query) of the view is stored
	** the data is retrieved from the underlying table based on the view definition		** the data is retrieved from the underlying table based on the view definition
			CREATE VIEW customer_south AS
			SELECT customer_id, first_name, region
			FROM customer
			WHERE lower(region) = 'south'

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

2017-11-14T14:40:46Z

← Older revision		Revision as of 14:40, 14 November 2017
Line 1:		Line 1:
	* A view is the representation of a S		* A view is the representation of a SQL statement that is stored in memory so that it can easily be re-used
			** A view gives a view of the table as defined by the select statement in the view defination
			** View does not store data separately
			** Only definition (query) of the view is stored
			** the data is retrieved from the underlying table based on the view definition

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

2017-11-14T14:39:09Z

Created page with "* A view is the representation of a S Back To Top- Home - Category"

New page

* A view is the representation of a S

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