MIS 325 Lecture Notes - Lecture 5: Result Set, Sql, Stored Procedure

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 325
• Professor: Ayvaci

Document Summary

Alter user: changes the definition of an existing user. Alter table: changes the definition of an existing table. Alter sequence: changes the definition of an existing sequence. Alter index: changes the structure of an existing index. Select (query): names columns to be retrieved. From: names table that contains the columns (base table) Where: gives criteria for the rows to be selected. Calculated values exist only in the results of the query. Result set (result table): returned by the select statement. Join: retrieves data from two tables and joins it together in a single result set. Inner join: rows from the two tables in the join are included in the result table only if their related columns match. Outer join: lets you include all rows from a table even if the other table doesn"t have a matching row. View: a predefined query that provides another way of viewing the data that"s stored in a table.