Populate a Table from a Stored Procedure
I created a test database with the following tables and columns:
test_database
tbl_hwconf(col_swID, col_CPU)
tbl_issue(col_issueID, col_comment)
tbl_swconf(col_swID, col_VM)
tbl_users(col_userID, col_fname, col_lname)
tbl_reports(col_userID, col_fname, col_lname, col_date_range)
I'm pretending that once a week a report is printed up using the data from tbl_reports. I'd like to create a stored procedure that queries all the tables except for tbl_reports, and then aliases the columns I want to be the same names as the columns in tbl_reports. Then I would like to set it up that every Friday that stored procedure is fired off, and the data populates tbl_reports. Then the report writer would just run a SELECT * to get all the information for his report whenever he was ready.
Does anyone know how to do this?
Subject
Written By
Posted
Populate a Table from a Stored Procedure
April 22, 2016 09:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.