Đang chuẩn bị liên kết để tải về tài liệu:
Oracle SQL Plus The Definitive Guide- P45

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Oracle SQL Plus The Definitive Guide- P45:Every day, computer professionals the world over wake up, travel to the office, sit down in front of a computer, and begin another day working with that database called Oracle. Programmers write queries and stored procedures. Database administrators monitor performance, make database changes, and perform other maintenance tasks. Operations people may need to back up or recover a database. | previous page page_403 next page Page 403 If the feature had been turned off in the above example the percent sign would have been placed in the buffer as part of the SELECT statement. SUFFIX The SUFFIX setting controls the default extension used for command files SET SUF FIX extension where SET SUF FIX Is the command which may be abbreviated to SET SUF. extension Is the default extension to use when referring to SQL files. The default value for this setting is SQL. This setting is used by commands such as START @ SAVE and others that refer to SQL files. It does not apply to files created with the SPOOL command. Operational Settings Operational settings control various aspects of how your commands are executed and how SQL Plus interacts with the database. You can control the following items APPINFO Controls automatic registration of command files using the DBMS_ APPLICATION_INFO package. ARRAYSIZE Is the number of rows SQL Plus will return at once from the database. AUTOCOMMIT Controls whether or not SQL Plus automatically commits your changes. CLOSECURSOR Controls whether or not SQL Plus keeps the statement cursor open all the time. COMPATIBILITY Controls whether SQL Plus acts as if it is connected to a version 7 database or a version 8 database. COPYCOMMIT Controls how often SQL Plus commits during the execution of a COPY command. previous page page_403 next page previous page page_404 next page Page 404 FLAGGER Controls whether or not SQL Plus checks your statements for compliance with ANSI ISO syntax. FLUSH Controls whether or not output may be buffered. The following sections describe the operational settings in detail. SET APPINFO The APPINFO setting controls whether or not SQL Plus automatically registers command files using the DBMS_APPLICATION_INFO package SET APPI NFO OFF ON app_text where SET APPI NFO Is the command which may be abbreviated to SET APP. OFF Disables the automatic registration of command file names. With this off SQL Plus will make an .