1Oracle 概述和体系结构1.pptVIP

Oracle 入门 目标 学习完本课之后，你将掌握以下内容: 了解什么是RDBMS和ORDBMS Oracle 体系结构 Oracle服务器的启动和关闭，以及相关工具的使用 ODBMS ORDBMS ORDBMS ORDBMS ORDBMS ORDBMS ORDBMS ORDBMS Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle 体系结构 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Oracle Server启动和关闭 Capabilities of SQL SELECT Statements A SELECT statement retrieves information from the database. Using a SELECT statement, you can do the following: 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 selectively restrict the rows that you see. 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. Join: 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 will learn more about joins in a later lesson. Instructor Note Inform students that selection and projection are often considered horizontal and vertical partitioning. Capabilities of SQL SELECT Statements A SELECT statement retrieves information from the database. Using a SELECT statement, you can do the following: 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 selectively restrict the rows that you see. Projection: You can use the projection capability