{"id":6056,"date":"2023-02-27T14:16:16","date_gmt":"2023-02-27T14:16:16","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/print-multiple-formatted-records\/"},"modified":"2023-02-27T14:16:16","modified_gmt":"2023-02-27T14:16:16","slug":"print-multiple-formatted-records","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/print-multiple-formatted-records\/","title":{"rendered":"Print multiple formatted records"},"content":{"rendered":"<div class=\"col-sm-12 messageContent\">\n <b>Learning Goal: <\/b>I&#8217;m working on a mysql question and need the explanation and answer to help me learn.<\/p>\n<p>What would the spool output look like for this (have attached coressponding document):<\/p>\n<p>SPOOL output<\/p>\n<p>Set SERVEROUTPUT ON to use the DBMS_OUTPUT package<\/p>\n<p>Declare variables for the entire record using %ROWTYPE<\/p>\n<p>Use FOR\/IN to read all records from DDI.LEDGER_VIEW<\/p>\n<p>The SELECT statement should read all fields from DDI.LEDGER_VIEW<\/p>\n<p>where REGDATE = &#8217;01-JUN-15&#8242; ordered by ROOMNUM<\/p>\n<p>Use DBMS__OUTPUT.OUTPUT_LINE to print the values for each field<\/p>\n<p>concatenate FIRSTNAME and LASTNAME into a single name and use&#8221;<\/p>\n<p>TO_CHAR to format dates as &#8216;MM\/DD\/YYYY&#8217; and currency as &#8216;999,999.00&#8217;<\/p>\n<p>Compile and run the procedure<\/p>\n<p>Close spool<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Learning Goal: I&#8217;m working on a mysql question and need the explanation and answer to help me learn. What would the spool output look like for this (have attached coressponding document): SPOOL output Set SERVEROUTPUT ON to use the DBMS_OUTPUT package Declare variables for the entire record using %ROWTYPE Use FOR\/IN to read all records [&hellip;]<\/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\/6056"}],"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=6056"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/6056\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=6056"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=6056"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=6056"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=6056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}