| Report and Save [message #374976] |
Mon, 16 July 2001 20:27  |
ZAN
Messages: 3
Registered: July 2001
|
Junior Member |
|
|
Dear Friends:
I am new to Oracle and I have Oracle 8i Personal edition on my PC. I have windows 98.
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. I can only save the Querry By using the Save command in the invoke editor
SAVE C:\Report REPLACE
How should I save the colums and page size etc with the querry for future use. 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
E-mail : mschalla@aol.com
|
|
|
|
| Re: Report and Save [message #374986 is a reply to message #374976] |
Tue, 17 July 2001 09:09  |
kavithask
Messages: 34
Registered: March 2001
Location: London
|
Member |
|
|
Hi,
When you type the SQL commands, type them into a notepad file and save it. Enter SQL*Plus and execute the file.
For eg: if the filename is Report and its saved in C:\MyFiles
Save the file as Report.SQL and save it under C:\MyFiles.
Enter SQL*Plus and type in
@c:\myfiles\report
This will execute the report.sql and print the output on screen.
Cheers,
Kavitha
|
|
|
|
| Re: Follow up Report and Save [message #375009 is a reply to message #374986] |
Wed, 18 July 2001 14:58 |
ZAN
Messages: 3
Registered: July 2001
|
Junior Member |
|
|
Thanks for the reply:
But C:\Myfiles\report only works when I am using a database for that particular time only. If I want to see what changes I made the next day I only see the querry those changes are not saved.
Like the changes I made in columns, page size etc.
How should I do that. My file name is Report. How should I save it so I can see those changes next time.
Thank you for your time and sharing your knowledge.
|
|
|
|
| Re: Follow up Report and Save [message #375010 is a reply to message #374986] |
Wed, 18 July 2001 15:03 |
ZAN
Messages: 3
Registered: July 2001
|
Junior Member |
|
|
Thanks for the reply:
But C:\Myfiles\report only works when I am using a database for that particular time only. If I want to see what changes I made the next day I only see the querry those changes are not saved.
Like the changes I made in columns, page size etc.
How should I do that. My file name is Report. How should I save it so I can see those changes next time.
Thank you for your time and sharing your knowledge.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
