Pl Help: How to save QUERRY W/ohter formating commands

From: ZAN <mschalla_at_aol.com>
Date: 21 Jul 2001 20:55:04 -0700
Message-ID: <655a983c.0107211955.3579b428_at_posting.google.com>


> I am new to Oracle and I have Oracle 8i Personal edition on my PC. I have
> windows 98.I have OREILLY BOOK ORACLE SQL PLUS (DEFINITIVE GUIDE) by
> Jonathan Gennick and I am in chapter 3 where I am having problems saving the
> colums and with other formating commands with the querry for later use. I can
> only save it temporary in the buffer when I am using Note pad. But once I
> exit the database it is gone and I have to type the COLUMN and other commands
> again. When I type the GET command to retrive I can only get the querry not
> the ohter commands that I had typed like the colums etc... Pages 73.(Format
> the Colums and other commands) Your help will be greatly appreciated.
>
> I am having the following problem. Whenever I make changes like add new
> columns or edit colums I have to type it again and again. I cannot save it. I
> can only save the Querry By using the Save command
> SAVE C:\Report REPLACE
> How should I save the colums and page size etc with the querry for future
> use. If I save it in the buffer it is only temporary but if I want to make
> chages after aday or two I have to retype the columns and other formating
> commands again and again. How to save it for future?
>
> Please explain by using the following example. Say the file name is Report
>
> COLUMN employee_name HEADING 'Employee Name'
> COLUMN project_name HEADING 'Project Name
> COlumn SUM(PH.Hours_LOGGED) HEADING 'Hours'
> COLUMN SUM(PH>DOLLARS_CHARGED)HEADING 'Dollars/Charged
> SELECT E.EMPLOYEE_NAME,
> P.PROJECT_NAME,
> SUM(PH.HOURS_LOGGED)hours_logged,
> SUM(PH.DOLLARS_CHARGED)dollars_charged
> FROM EMPLOYEE E,
> PROJECT P,
> PROJECT_HOURS PH
> WHERE E.EMPLOYEE_ID = PH.EMPLOYEE_ID
> AND P.PROJECT_ID = PH.PROJECT_ID
> GROUP BY E.EMPLOYEE_ID, E.EMPLOYEE_NAME,
> P.PROJECT_ID, P.PROJECT_NAME
>
>
> Thank you for your time
> Please e-mail me your answer to
> E-mail : mschalla_at_aol.com
>
>
>
>
Received on Sun Jul 22 2001 - 05:55:04 CEST

Original text of this message