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

20 views2 pages

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.

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related Documents