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

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- P17: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_137 next page Page 137 INDEX PROJECT_HOURS_EMP_DATE TABLESPACE USER_DATA COLUMNS EMPLOYEE_ID TIME_LOG_DATE UNIQUE INDEX PROJECT_HOURS_PK TABLESPACE USER_DATA COLUMNS PROJECT_ID EMPLOYEE_ID TIME_LOG_DATE 6 rows selected. Commit complete. Cleaning Up the Display As you ve followed the development of the LIST_INDEXES script you no doubt saw the following lines interspersed in the output old 9 AND ui.table_name UPPER table_name new 9 AND ui.table_name UPPER project_hours 6 rows selected. Commit complete. These lines add no value to the script and serve only to clutter up the output. It would be nice to get rid of them and it is possible to do that by turning verification and feedback off. The commands to do that are described next. Turning Verification Off Verification refers to what SQL Plus does when it encounters a line of script containing substitution variables. By default SQL Plus verifies the substitution by displaying both the old and the new versions of the line involved. The output from verification looks like this old 9 new 9 AND ui.table_name AND ui.tablename UPPER table_name UPPER project_hours Sometimes this verification is useful especially when you are first developing a script because it allows you to see for sure whether or not your substitutions are being made correctly. Once you ve developed a script though it s nice to be able to turn this output off. You can turn verification off by adding the following command to your script SET VERIFY OFF previous page page_137 next page previous page page_138 next page Page 138 Turning verification off makes your output a lot cleaner and is especially helpful if the script is a report that may be run by an end user. Turning Feedback Off Feedback refers to the short messages that SQL Plus displays after executing a SQL statement such as SELECT or COMMIT. Feedback looks like this 6 rows selected. Commit complete. As with verification feedback often clutters up the output from a script. The .