After completing this appendix, you should be able to do the following: Log in to SQL*Plus Edit SQL commands Format output using SQL*Plus commands Interact with script files | Using SQL*Plus Schedule: Topic Timing Lecture 20 minutes Total 20 minutes Objectives After completing this appendix, you should be able to do the following: Log in to SQL*Plus Edit SQL commands Format output using SQL*Plus commands Interact with script files Lesson Aim You may want to create SELECT statements that can be used again and again. This lesson also covers the use of SQL*Plus commands to execute SQL statements. You learn how to format output using SQL*Plus commands, edit SQL commands, and save scripts in SQL*Plus. SQL and SQL*Plus Interaction SQL*Plus Buffer Server SQL statements Query results SQL scripts SQL and SQL*Plus SQL is a command language for communication with the Oracle9i Server from any tool or application. Oracle SQL contains many extensions. When you enter a SQL statement, it is stored in a part of memory called the SQL buffer and remains there until you enter a new SQL statement. SQL*Plus is an Oracle tool that recognizes and submits SQL statements to the . | Using SQL*Plus Schedule: Topic Timing Lecture 20 minutes Total 20 minutes Objectives After completing this appendix, you should be able to do the following: Log in to SQL*Plus Edit SQL commands Format output using SQL*Plus commands Interact with script files Lesson Aim You may want to create SELECT statements that can be used again and again. This lesson also covers the use of SQL*Plus commands to execute SQL statements. You learn how to format output using SQL*Plus commands, edit SQL commands, and save scripts in SQL*Plus. SQL and SQL*Plus Interaction SQL*Plus Buffer Server SQL statements Query results SQL scripts SQL and SQL*Plus SQL is a command language for communication with the Oracle9i Server from any tool or application. Oracle SQL contains many extensions. When you enter a SQL statement, it is stored in a part of memory called the SQL buffer and remains there until you enter a new SQL statement. SQL*Plus is an Oracle tool that recognizes and submits SQL statements to the Oracle9i Server for execution. It contains its own command language. Features of SQL SQL can be used by a range of users, including those with little or no programming experience. It is a nonprocedural language. It reduces the amount of time required for creating and maintaining systems. It is an English-like language. Features of SQL*Plus SQL*Plus accepts ad hoc entry of statements. It accepts SQL input from files. It provides a line editor for modifying SQL statements. It controls environmental settings. It formats query results into basic reports. It accesses local and remote databases. SQL Statements versus SQL*Plus Commands SQL statements SQL A language ANSI standard Keywords cannot be abbreviated Statements manipulate data and table definitions in the database SQL*Plus An environment Oracle proprietary Keywords can be abbreviated Commands do not allow manipulation of values in the database SQL buffer SQL*Plus commands SQL*Plus buffer SQL and SQL*Plus (continued) The following table .
