Exam Cram 2 In This Book You"ll Learn How To: Retrieve data using the select statement. Filter rows with the where clause. Sort data with the order by clause. Use operators, conditions, pseudo columns expressions, and single row functions. Group and summarize rows with the group by clause. Construct sub queries and other specialized queries. Format with SQL*Plus. Change data using DML insert, update, and delete commands. Use DDL commands for creating and maintaining tables, their data types, and constraints. Use DDL commands for creating and maintaining views, indexes, sequences, and synonyms. Implement Oracle database security.