Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle SQL Plus The Definitive Guide- P12: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_87 next page Page 87 LEFT - - SKIP 2 BTITLE LEFT - - SKIP 1 - RIGHT Page FROMAT 999 SQL.PNO --Format the columns COLUMN employee_id HEADING Emp ID FORMAT 9999 COLUMN employee_name HEADING Employee Name FORMAT A16 WORD_WRAPPED COLUMN project_id HEADING Proj ID FORMAT 9999 COLUMN porject_name HEADING Project Name FORMAT A12 WORD_WRAPPED COLUMN hours_logged HEADING Hours FORMAT 9 999 COLUMN dollars_charged HEADING Dollars Charged FORMAT 999 999.99 --Execute the query to generate the report. SELECT E.EMPLOYEE_ID E.EMPLOYEE_NAME P.PROJECT_ID P.PROJECT_NAME TO_CHAR PH.TIME_LOG_DATE dd-Mon-yyyy time_log_date PH.HOURS_LOGGED PH.DOLLARS_CHARGED FROM EMPLOYEE E PROJECT P PROJECT_HOURS PH WHERE E.EMPLOYEE_ID PH.EMPLOYEE_ID AND P.PROJECT_ID PH.PROJECT_ID ORDER BY E.EMPLOYEE_ID P.PROJECT_ID PH.TIME_LOG_DATE When you execute this script here s what the output will look this The Fictional Company I.S. Department Project Hours and Dollars Detail Emp Id Employee Name Proj ID Project Name Dollars Date Hours Charged 101 Jonathan Gennick 1001 Corporate Web 01-Jan-1998 1 169.00 Site 101 Jonathan Gennick 1001 Corporate Web 01-Mar -1998 3 507.00 Site 101 Jonathan Gennic 1001 Corporate Web 01-May-1998 5 845.00 Site 101 Jonathan Gennick 1001 Corporate Web 01-Jul-1998 7 1 183.00 Site previous page page_87 next page previous page page_88 next page Page 88 101 Jonathan Gennick 1001 Corporate Site Web 01-Sep-1998 1 169.00 101 1998 101 1998 101 Jonathan 0 3 Jonathan 7 1 Jonathan Gennick 507.00 Gennick 183.00 Gennick 1001 1002 1002 Corporate Site Year 2000 Year 2000 Web Fixes Fixes 01-Nov- 01-Feb- 01-Apr-1998 1 169.00 101 Jonathan Gennick 1002 Year 2000 Fixes 01-Jun-1998 3 507.00 101 Jonathan Gennick 1002 Year 2000 Fixes 01-Aug-1998 5 845.00 101 1998 101 Jonathan 7 1 Jonathan Gennick 183.00 Gennick 1002 1002 Year Year 2002 2002 Fixes Fixes 01-Oct- 01-Dec-1998 1 169.00 The first four columns repeat the same values over and over again. This makes the report a bit difficult to .
