Title: Class Outline 24
Course: KVCC BUS210 > Section: Class Outlines

i.           Sub Queries

a.           Rules from chapter 7

b.           Examples

c.           Returns

i.           One Single Value

ii.           A list of Values

iii.           A virtual table

d.           Where

e.           In

f.           Having

g.           Any and All

h.           From

i.           Attribute List

ii.           Correlated Subqueries

iii.           SQL Functions

a.           DATE and TIME

b.           NUMERIC

c.           STRING

d.           CONVERSION

iv.           Relational Set Operators

a.           UNION

b.           INTERSECT

c.           EXCEPT(MINUS)

d.           Set-oriented

e.           Union Compatible

f.           Commands

i.           Union

ii.           Union All

iii.           Intersect

iv.           Except

v.           Alternatives

v.           Virtual Tables/Views

a.           View

b.           Base tables

vi.           Updateable views

vii.           Oracle Sequences

viii.           Procedural SQL

a.           Persistent stored module PSM

b.           Procedural Language SQL PL/SQL

i.           Anonymous blocks

ii.           Data Types

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 24.pdf