Notes April 8

Notes April 8 - Roll back to save point specifies names...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
April 8, 2008 Advanced SQL Equi-join or Natural join Sub-queries – a query whose inner query provides values for the search condition of the out query Transaction – a unit of work o Note: a single SQL command is automatically committed/roll backed after the command is run buy multiple SQL commands require BEGIN/END Roll back – undoes all data changes in the current transaction
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Roll back to save point specifies names roll back segment for the transaction Commit ends the current transaction / forces a write to disk Multiple row sub-query o <ANY means less than the maximum value o IN or =ANY o >ANY means more than the minimum value o >ALL means more than then maximum value o <ALL means less than the minimum value...
View Full Document

This note was uploaded on 04/19/2008 for the course SW 402 taught by Professor Coccran during the Spring '08 term at Fairfield.

Ask a homework question - tutors are online