达内 数据库开发新.ppt

ORACLE SQL;INTRODUCTION;INTRODUCTION;Where is Data stored?;Basic Unit of Data Storage;Language of Data Access-SQL;DB and DBMS;Logging in to SQL*Plus;Displaying Table Structure;SELECT Statement;;SELECT statement;The Basic Query Block;Selecting All Columns, All Rows;Selecting Specific Columns;Arithmetic Expressions;Display the annual salary for all employees.;Column Aliases;Operator Precedence;Concatenation Operator;Concatenation Operator: Example;Literal Character String;Literal Character String: Example;Managing Null Values;NVL Function;Duplicate Rows;DISTINCT with Multiple Columns;SELECT stat