Đang chuẩn bị liên kết để tải về tài liệu:
Using SQL *Plus to Create Report and Manage Pl/SQL code

SQL*Plus is an environment in which you can Execute SQL statements to retrieve, modify, add, and remove data from database tables. Format, perform calculations on, store, and print query results in the form of reports. Issue SQL statements to create, alter, and remove database tables. Create anonymous blocks, subprograms, database triggers using procedural language extension, PL/SQL. SQL*Plus has a variety of commands you need to use to execute subprograms, pass values in and out of PL/SQL blocks, and debug your code. SQL*Plus commands may be divided into the following main categories | c Using SQL Plus to Create Reports and Manage PL SQL Code ORACLG Objectives Differentiate between SQL and SQL Plus commands. Identify SET commands used to control the SQL Plus environment. Customize reports using SQL Plus formatting commands. Create and modify anonymous blocks and program units with SQL Plus and the online editor. Execute SQL Plus commands anonymous blocks program units and SQL statements. Compile procedures and functions. Embed messages to assist with debugging code. C-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives This lesson covers formatting query output to produce simple reports controlling the SQL Plus environment and manipulating PL SQL code using SQL Plus. At the end of this lesson you should be able to Differentiate between SQL and SQL Plus commands. Identify SET commands used to control the SQL Plus environment. Customize reports using SQL Plus formatting commands. Create and modify anonymous blocks and program units with SQL Plus and the online editor. Execute SQL Plus commands anonymous blocks program units and SQL statements. Compile procedures and functions. Embed messages to assist with debugging code. Using SQL Plus to Create Reports and Manage PL SQL Code .