Basic HTML version of Foils prepared 7 October 97

Foil 18 Data Manipulation Language statements (DML)

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
Query or manipulate data in existing schema objects.
More specifically functionality is:
  • remove rows from tables or views (DELETE)
  • see the execution plan for a SQL statment (EXPLAIN PLAN)
  • add new rows of data into a table or view (INSERT)
  • lock a table or view, temporarily limiting other users' access to it (LOCK TABLE)
  • retrieve data from one or more tables and views (SELECT)
  • change column values in existing rows of a table or view (UPDATE)
DML statements are the most frequently used SQL statements by developers

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998