SQL Language Basics
Oracle9i is a relational database. All relational databases are based on SQL (Structured Query Language). The better you understand SQL, the more productive you can be in the relational world.
SQL actually has three distinct parts: the query language or SELECT; data manipulation language (DML) that comprises the UPDATE and DELETE commands; and the data definition language (DDL) that has the ALTER, CREATE, RENAME, and DROP commands. There are several various other commands that perform specific functions, such as COMMIT, which tells Oracle that this is desired information and to save it to the database and ROLLBACK, which tells Oracle to discard the changes made by the last SQL statement prior to a COMMIT. There are also a ...
Get Oracle9i™ Development by Example 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.
