{"id":7022,"date":"2023-03-02T18:07:47","date_gmt":"2023-03-02T18:07:47","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/mysql-question\/"},"modified":"2023-03-02T18:07:47","modified_gmt":"2023-03-02T18:07:47","slug":"mysql-question","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/mysql-question\/","title":{"rendered":"MySQL Question"},"content":{"rendered":"
\n Learning Goal: <\/b>I’m working on a mysql multi-part question and need the explanation and answer to help me learn.<\/p>\n

Needing a code and spool output for this as well. It uses the same database as the last project you did for me, but I attached them again in case. The spool output is the most important. Here are the instructions:<\/p>\n

    \n
  1. SPOOL your output to c:\\folder\\project6spool.txt<\/li>\n
  2. Set SERVEROUTPUT ON FORMAT WRAPPED to use the
    DBMS_OUTPUT package and preserve leading spaces<\/li>\n
  3. Declare variables for the entire record using %ROWTYPE
    Add a variable to remember last ROOMNUM
    Add accumulators for subtotal and grandtotal<\/li>\n
  4. Add procedures for HEAD_OF_FORM, FORM_BREAK, and END_OF_FORM<\/li>\n
  5. Use FOR\/IN to read all records from DDI.LEDGER_VIEW<\/li>\n
  6. The SELECT statement should read all fields from DDI.LEDGER_VIEW
    where REGDATE < ’08-JUN-15′ (Monday \u00e2\u20ac\u201c Friday for Week One)
    order by ROOMNUM and REGDATE<\/li>\n
  7. Read each record using LOOP\/END LOOP
    Use IF\/ELSEIF\/ELSE\/END IF to decide which procedures to use based on Last_room
    Print ROOMNUM, REGDATE, REGID, Name (FIRSTNAME || ‘ ‘ || LASTNAME), ROOMRATE
    using TO_CHAR to format REGDATE as ‘MM\/DD\/YYYY’ and ROOMRATE as ‘999,999.00’<\/li>\n
  8. Be sure to add a FORM_BREAK and an END_OF_FORM after the END LOOP<\/li>\n
  9. Use DBMS__OUTPUT.OUTPUT_LINE to print the values for each field
    concatenate FIRSTNAME and LASTNAME into a single name and use”
    TO_CHAR to format dates as ‘MM\/DD\/YYYY’ and currency as ‘999,999.00’<\/li>\n
  10. Compile and run the procedure<\/li>\n
  11. Close spool<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Learning Goal: I’m working on a mysql multi-part question and need the explanation and answer to help me learn. Needing a code and spool output for this as well. It uses the same database as the last project you did for me, but I attached them again in case. The spool output is the most […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[853],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7022"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=7022"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/7022\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=7022"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=7022"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=7022"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=7022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}