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

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- P42: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_373 next page Page 373 SET HEA DING ON OFF where SETHEA DING Is the command which may be abbreviated SET HEA. ON Causes column headings to print when you select data. OFF Suppresses column headings. This setting is on by default so you normally get a column heading whenever you select or print data using either the SELECT command or the PRINT command. For example SQL SELECT FROM dual D X Change the value to OFF and your column headings go away. The following example shows this SQL SET HEADING OFF SQL SELECT FROM dual X Issuing a SET PAGESIZE 0 command will also turn headings off. If you are trying to enable headings and SET HEADING ON does not appear to be working then you should check the pagesize as well. SETLINESIZE Use SET LINESIZE to control the number of characters SQL Plus prints on one physical line. The default setting is 80. The maximum width is system-dependent. Under Windows 95 it is 32 767. SET LIN ESIZE line_width where SET LIN ESIZE Is the command which may be abbreviated to SET LIN. line_width Is the new line width expressed as a number of characters. previous page page_373 next page previous page page_374 next page Page 374 The linesize setting is also referenced by SQL Plus when you define any headers or footers see TTITLE BTITLE REPHEADER REPFOOTER that are centered or right-justified. SET MAXDATA MAXDATA is an obsolete setting that should no longer be used. SQL Plus supports it in order to be backwardcompatible. MAXDATA controls the maximum row length SQL Plus can handle. SET MAXD ATA max_row_width where SETMAXD ATA Is the command which may be abbreviated to SET MAXD. max_row_width Is the new setting for the maximum row width you expect to process. The default setting under Windows 95 is zero but may vary from one operating system to the next. Under some operating systems such as Windows 95 this setting seems to have no effect whatsoever on SQL Plus s behavior. SETNEWPAGE Controls the manner in which the transition from one .