PL/SQL Dynamic Content

-

 PROCEDURE prc_spreadsheet IS

  
  CURSOR c_reprice_data IS
    SELECT * FROM
    tbl_repricing_table
    ORDER BY ID desc;

  BEGIN
    owa_util.mime_header('application/octet-stream', FALSE);
    htp.p('Content-Disposition: attachment; filename=system_query_results_'||
to_char(sysdate, 'MM')||'-'||to_char(sysdate, 'DD')||'-'||
to_char(sysdate, 'YYYY')||'.xls');
    owa_util.http_header_close;
    
      htp.prn('ID'||chr(9));
      htp.prn('Date Created'||chr(9));
      htp.prn('User Created'||chr(9));
      htp.prn('Hot Rush?'||chr(9));
      htp.prn('Order #'||chr(9));
      htp.prn('Bill to #'||chr(9));
      htp.prn('Bill to Name'||chr(9));
      htp.prn('Trade'||chr(9));
      htp.prn('Comments'||chr(9));
      htp.prn('Pricing Analyst'||chr(9));
      htp.prn('Status'||chr(9));
      htp.prn('Line Count'||chr(9));
      htp.prn('User Completed'||chr(9));
      htp.prn('Date Submitted');
      htp.prn(chr(13));
    FOR r_reprice_data IN c_reprice_data LOOP
      htp.prn(r_reprice_data.id||chr(9));
      htp.prn(r_reprice_data.date_created||chr(9));
      htp.prn(r_reprice_data.user_created||chr(9));
      htp.prn(r_reprice_data.hot_rush||chr(9));
      htp.prn(r_reprice_data.order_number||chr(9));
      htp.prn(r_reprice_data.bill_to_number||chr(9));
      htp.prn(r_reprice_data.bill_to_name||chr(9));
      htp.prn(r_reprice_data.trade||chr(9));
      htp.prn(fnc_format_long_text(r_reprice_data.comments)||chr(9));
      htp.prn(r_reprice_data.pricing_analyst||chr(9));
      htp.prn(r_reprice_data.status||chr(9));
      htp.prn(r_reprice_data.line_count||chr(9));
      htp.prn(r_reprice_data.user_completed||chr(9));
      htp.prn(r_reprice_data.date_submitted);
     
      htp.prn(chr(13));
    
    END LOOP;

  END prc_spreadsheet;

END repricing;

Comments

Post a Comment

Popular posts from this blog

Project Management System ER Diagram

-
Image
  This article will discuss the step by step process on how to prepare the entity relationship diagram or ERD of the project entitled Project Management System. Project Management System is an information system that will manage the processes and transactions involved in monitoring and recording the updates of a project. The said project can be implemented in an offline settings but in most cases this is implemented in a live server or it simply means an online system. The first step in the development of the Project Management System is to prepare the ER diagram that will serve as the basis later on in the creation of the actual database. We will create and explain the process of making the entity relationship diagram of project management system. Let’s start from the symbols used in the ER Diagram. Entity is represented by the rectangle shape. The entity will be our database table of Project Management System later on. Attribute is represented by the oval shape. This will be the ...
Read more

Install and Configure OBIEE 12c on Linux VM

-
Image
Install and Configure OBIEE 12c on Linux VM · 1 Today we are going to be installing Oracle BI 12c on our Linux Virtual Machine. If you have not already created an Oracle Linux VM, I wrote a blog on how to do this  here . If you have not already installed Oracle Database 19c on your Linux VM, I wrote a blog on how to do this  here . This blog also assumes that you have access to the sample HR dataset that comes pre-installed with Oracle Database 19c. I covered how to access this in the Oracle 19c installation blog that I mentioned above. Before we begin, I just wanted to say good luck  and … Starting-up and opening the database If you have not already done so, log-in to your Linux instance’s GUI. Your screen should look like this. First, let’s start our listener and open-up our database. Open a new terminal window and execute the following command to start your listener, if it is not already started. If it has already been started, the terminal will let you know. lsnrctl s...
Read more

Web Based Hotel Room Management Information System

-
  Systematic management of records allow organization to know what records they have, and locate them easily, increase efficiency and effectiveness, make savings in administrations costs both in staff time and storage, support decision making, be accountable, achieve business objectives and targets, provide continuity in the event of a disaster, meet legislative and regulatory requirements, protect the interests of employees and clients. Records are valuable because of the information they contain and that information is only usable if it is correctly and legibly recorded in the first place, is then kept up to date, and is easily accessible when need Records in hotels are not commonly found in archives but when such records survive and find their way to an archives the information contained in the records are beneficial to a variety of researchers, including students, genealogists, and academics. Due to manual recording system, Hotels, Pension Houses, Apartments and the likes are e...
Read more