Oracle公司内部数据库培训资料基本SQLSELECT语句.pptVIP

内容总结 基本SQL SELECT语句。列举 SQL SELECT语句的功能。SQL SELECT 语句的功能。基本 SELECT 语句。SELECT *|{[DISTINCT] column|expression [alias],...}。SELECT *|{[DISTINCT] column|expression [alias],...}。SELECT 标识 选择哪些列。关键字不能被缩写也不能分行。紧跟列名，也可以在列名和别名之间加入关键字‘AS’，以便在别名中包含空格或特殊的字符并区分大小写。使用别名。把列与列，列与字符连接在一起。用 ‘||’表示。字符串可以是 SELECT 列表中的一个字符,数字,日期 第三十页，共三十页。 转载 Schedule: Timing Topic 40 minutes Lecture 25 minutes Practice 65 minutes Total Lesson Aim To extract data from the database, you need to use the structured query language (SQL) SELECT statement. You may need to restrict the columns that are displayed. This lesson describes all the SQL statements needed to perform these actions.You may want to create SELECT statements that can be used more than once. This lesson also covers the iSQL*Plus environment where you execute SQL statements. Note: iSQL*Plus is new in the Oracle9i product. It is a browser environment where you execute SQL commands. In prior releases of Oracle, SQL*Plus was the default environment where you executed SQL commands. SQL*Plus is still available and is described in Appendix C. Capabilities of SQL SELECT Statements A SELECT statement retrieves information from the database. Using a SELECT statement, you can do the following: Projection: You can use the projection capability in SQL to choose the columns in a table that you want returned by your query. You can choose as few or as many columns of the table as you require. Selection: You can use the selection capability in SQL to choose the rows in a table that you want returned by a query. You can use various criteria to restrict the rows that you see. Joining: You can use the join capability in SQL to bring together data that is stored in different tables by creating a link between them. You learn more about joins in a later lesson. Instructor Note Inform students that selection and projection are often considered horizontal and vertical partitioning. Basic SELECT Statement In its simplest form, a SELECT state