On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Saturday, July 3, 2010

SQL Statement Types


AcronymLanguagePurposeStatementsComments
DDLData DefinitionDefine Database· Create · Alter · Drop · Truncate · Comment · RenameAutocommit
DMLData ManipulationManaging data· Select · Insert · Update · Delete · Merge
· Call · Explain Plan · Lock Table
Can rollback
DCLData ControlSecurity· Grant · Revoke
TCLTransaction Control Manage DML· Commit · Savepoint · Rollback · Set Transaction

No comments:

Post a Comment