Great! Thanks for the information. Both appear to solve my requirement.
After a quick query, it does appear that the Case statement is returning the data more efficiently.
Santa, Thanks for introducing me to In-Line Views (hanging my head in shame for not knowing...)
Again, thanks for the...
Great! Thanks for the information.
After a quick query, it does appear that the Case statement is returning the data more efficiently.
Santa, Thanks for introducing me to In-Line Views (hanging my head in shame for not knowing...)
Again, thanks for the quick replies.
Enjoy.
Using Oracle 9i.
I have a table that stores the records in the following fashion:
prodID | sample | attribute | value
-----------------------------------
1445a | 1 | Thickness | 13.9
1445a | 2 | Thickness | 14
1445a | 3 | Thickness | 13.8
1445a | 1 | Drop | 0...
As you can probably see, my knowledge of materialized views is limited.
I just did some research on Refresh types...
I'm gonna go back and work on this solution for a while and either post more questions or explain what I did.
Thanks again for your assistance.
Here is what I'm thinking now...
Create the materialized view logs on the tables that I want the data from....
Then create a materialized view on these tables with a more complex query then usual..
Thanks for pointing out my obvious mistake...and more importantly, not doing so in an obnoxious manner.
I greatly appreciate that.
After your post, I attempted to create the MV on the reporting database and receive the following error:
ora-23413: table "" does not have a materialized view log...
using Oracle 9.
I'm trying to create a materialized view on a view but keep getting the following error.
The view does exist. I'm under the assumption that creating a materialized view on a view is done the same way as on a table.
ora-00942: table or view does not exist.
CREATE...
When the .dll is being developed in Visual Studio, a vb form from that .dll appears one way, (textbox size, label placement, etc.) than when compiled and hosted in an application.
Any suggestions as to what may cause this?
using IE 6.0.
I have an app that produces a URL on the .aspx page.
When this user clicks on the URL, IE attempts to open the Excel in the browser. Does not provide a Open-Save dialog.
I've gone into File Types, (Under Folder Options) and set the options to the same as my computer, but still...
jbenson001--
Well, that depends. If the report that the user is running will only be ran once a week. One minute is really not that big of a deal.
The number of rows is not the issue. I'm only returning, on average, 10.
The number of columns cannot be changed. This report will report on data...
Below is the view that is providing the data for the report.
When executing the query with the parameters that is being passed in, it executes in about 1 minute.
CREATE OR REPLACE FORCE VIEW CIDDEV.VW_RDE_ZEUS_LDS
(
FACILITY,
PROTOCOLID,
MOLOTID,
MONOMER_LOTID,
MIX_DATE...
That is a slight problem...the last function that is being called is the Dispose() in the Report.Master.
All goes well for this function, even when called with the larger DataSet. There does seem to be a timing issue, because, regardless of dataset, if I step through the Dispose() function and...
Thanks again for the reply...and simplifying my code.
The only problem:
If I change
myDataset2.Tables.Add(SourceData_Build2());
to
myDataset2.Tables.Add(SourceData_Build());
The same results occur, the loading panel never gets turned off. The second code snippet [SourceData_Build()]...
good point on the Dispose method.
You're right, I shortened the code snippet to ask the question...always a bad move.
here is my Button click event:
protected void btnDownload_Click(object sender, System.EventArgs e)
{
MessageBox.Text = "";
string result = "0"...
I have this app that is passing a dataset to an Excel writer. The database call in SourceData_Build() returns only about 10 rows of data but contains almost 200 columns.
The app has no problem with Converting to Excel and saving a file on the webserver. The issue is that the Panel is never...
I have a page that contains a Panel with a few controls and one that is inherited(btnDownload) from the Master page.
When the btnDownload is clicked, the code is going off and building a Dataset. This Dataset is built on a view which contains 200+ columns with only a few rows of data. I'm...
Well, it must be Christmas in April because Santa just brought me a gift. It worked and provided me the results I needed.
Thanks for taking the time.
Enjoy,
I'm trying to select records that have workdates greater than 4/1/2009.
workdate is of type Date is stamped with sysdate when inserted so it contains Date & Time
How can I achieve this?
SELECT * FROM tb_my_table
WHERE to_char(workdate, 'MM/DD/YYYY') > ('4/1/2009')
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.