TAILIEUCHUNG - Oracle SQL Plus The Definitive Guide- P11

Oracle SQL Plus The Definitive Guide- P11: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_77 next page Page 77 BTI TLE OFF ON COL x S KIP x TAB x LE FT CE NTER BOLD FOR MAT format_spec text variable. where BTI TLE May be abbreviated BTI. Issuing the BTITLE command with no parameters causes SQL Plus to display the current bottom title setting. OFF Turns the page footer off but does not erase its definition. You can turn it back on again with ON. ON Turns on printing of page footers. The default footer if you do not specify another will be the first part of the SELECT statement. COLx Causes any footer text following this parameter to print at the specified column position. S KIP x May be abbreviated as S and inserts the specified number of line breaks before printing any subsequent footer text. TABx TAB is similar to COL but moves you the specified number of columns relative to the current position. Negative numbers move you backwards. TAB has nothing whatsoever to do with tab characters. LE FT May be abbreviated LE and causes subsequent footer text to be printed beginning at the leftmost column of the current footer line. CE NTER May be abbreviated CE and causes subsequent footer text to be centered within the current line. The LINESIZE setting controls the line width. R IGHT May be abbreviated R and causes subsequent footer text to be printed flush right. The LINESIZE setting controls where SQL Plus thinks the right end of the line is. page_77 previous page next page previous page page_78 next page Page 78 BOLD Makes your footer bold by printing it three times. Only title text following the BOLD command is repeated on each line. There is not a NOBOLD parameter. FOR MAT formatspec May be abbreviated to FOR and allows you to control how subsequent numeric data in the footer is displayed. The format elements you can use here are the same as for the COLUMN command and are described in Appendix B. It is possible to specify a character format such as A20 but that has no effect on subsequent character strings. text Is any text you want to .

TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.