SMSE03_Oracle管理工具SQLPLUS.ppt

Oracle数据库管理基础SQL Plus和SQLPL/SQL Database Administration Tools 主要内容 PL/SQL、SQL和SQL*Plus之间的关系 SQL*Plus连接数据库的三种方式 在SQL*Plus中执行的三种命令 使用替换变量执行动态SQL语句 注意使用系统变量控制SQL*Plus运行环境 Oracle SQL脚本及其使用 对结果集的处理（报表工具） PL/SQL Relation Database Properties Access and modify objects in the database by executing SQL commands Contains a collection of tables with no physical pointers Uses a set of operations Modifiable online Full data independence SQL and SQL*Plus Interaction Differentiate between SQL and SQL*Plus SQL*Plus, SQL and PL/SQL SQL*Plus: An Oracle tool that recognizes and submits SQL and PL/SQL statements to the Server for execution and contains its own command language. SQL: A command language for communication with the Oracle Server from any tool or application. Oracle SQL contains many extensions. PL/SQL An Oracle procedural language for writing application logic and manipulating data inside/outside the database. Languages Curriculum for Oracle PL/SQL、SQL和SQL*Plus间的关系 Oracle数据库视为餐馆的厨房:厨房中有两种重要的厨师，分别为SQL和PL/SQL。 SQL*Plus是将我们的菜单（脚本、命令或程序）拿入厨房（数据库）的服务员。 象服务员一样， SQL*Plus知道什么样的订单可以处理，而什么样的订单要拿到特定的厨师那儿进行处理。例如SQL*Plus可以调整屏幕上行的显示宽度而不必利用数据库。 厨师脑中储存的订单“配方”就象数据库中储存的PL/SQL元素（触发器、存储函数、存储过程或程序包） Overview of SQL*Plus After you log into SQL*Plus, you can: Describe the table structure Edit your SQL statement Execute SQL from SQL*Plus Format, perform calculations on, store, and print query results in the form of reports Load /Save SQL statements to files and append SQL statements to files Execute statements stored in saved files SQL*Plus command categories: SQL statements, PL/SQL blocks and SQL*Plus commands Logging in to SQL*Plus 启动SQL*Plus但不连接到数据库 交互登录启动SQL*Plus 指定用户名和密码启动SQL*Plus Logging in to SQL*Plus 系统管理员登录 操作系统验证方式 密码文件验证方式 SQL*Plus的种类 SQL*Plus Commands SQL*Plus commands have a different syntax from SQL commands or PL/SQL blocks. You can continue a long SQL*Plus command by typing a hyphen at the end of the line and pressing Return. You do not need to end a SQL*Plus command w