TAILIEUCHUNG - Oracle SQL*Plus The Definitive Guide- P2

Oracle SQL*Plus The Definitive Guide- P2: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_xi next page Page xi Preface 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. Analysts may need to explore the structure of a database to answer the question What s out there Testers may work on developing and loading test data. A wide variety of people perform a wide variety of tasks yet the vast majority of them are likely to have one thing in commonSQL Plus. SQL Plus is the command-line interface to the Oracle database. It s a client-server application that allows you to enter and execute SQL statements and PL SQL blocks. One of the most common uses for SQL Plus is as an ad hoc query tool. You type in a SELECT statement execute it and see what results come back from the database. Programmers do this all the time when developing queries and when experimenting with Oracle s built-in functions. Database administrators sometimes issue queries against Oracle s data dictionary tables in order to see what objects are out there in the database. One important capability of SQL Plus is its ability to format and paginate query results. You can enter a SELECT statement execute it and have the results formatted so you can print them and produce a credible-looking report. SQL Plus implements a full range of formatting commands that allow you to add page headers and footers to your reports. There are also commands that allow you to format the data displayed in the report. You can control column headings number formats and column widths. Another important capability of SQL Plus and one you should take advantage of if you don t already is its ability to run predefined SQL script files. A script file is page_xi previous page next

TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
10    171    3    23-11-2024
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.