CRITICAL SKILL 2.1
Learn the SQL Statement Components
Before learning many of the SQL commands that you will use frequently, first let’s take a look at the two different categories into which SQL statements are classified. They are DDL, or data definition language, and DML, or data manipulation language. The majority of this chapter will deal with the latter.
DDL
DDL is the set of SQL statements that define or delete database objects such as tables or views. For the purposes of this chapter, we will concentrate on dealing with tables. Examples of DDL are any SQL statements that begin with create, alter, drop, and grant. Table 2-1 is a sample list of some DDL statements. It does not completely represent the many varied statements that all have ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
