Recent content by xuewei

Hi AccessAce, I figured out the method to detect changing: SELECT Table2.ID, table2.Name, table2.Address, table1.age FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID WHERE table1.Name <> table2.Name OR table1.Address <> table2.Address OR table1.age <> table2.age; Thank you for your...

Thanks a lot, AccessAce, I think it should work and I will try it later. I will let you know the results after I figure it out. Hava a great day! Xuewei

Hi AccessAce, Your suggestion is one possibility to find the changed records. I will try it later. At the same time, do you think if I can create a procedure and use VBscript to do that? Thanks Xuewei

Hi AccessAce, Thank you very much for the solutions. I tried it, it works fine for the &quot;add&quot; and &quot;delete&quot;. I just changed a little bit of the SQL: SELECT Table1.ID, table1.Name, table1.Address,table1.age,&quot;Delete&quot; as Action FROM Table2 RIGHT JOIN Table1 ON...

Hi AccessAce, Thank you for your response. I tried your suggestion. Using the Find Unmatched Query Wizard, we can find records in one table that don't have related records in another table. However, I want to find not only added records, but also changed and deleted records. Do you have...

Hello, I have two tables in Access database with the same definition. For example, table1 and table2 have exactly the same data fields but have some different records. I want to find what records have been added, deleted, or changed in table2 compare to table1. Are there any methods to do the...

Hi Turkbear, Thank you for the response. There are 68650 records in gis_data and 66000 records in mail_out. They are not indexed. The database is Oracle9i running on Windows2000. For that statement, it run more than 8 hours and I still can't get results. I try to run Explain Plan on the...

Hi, I have a simple question about a pl/sql as following: update mail_out pmo set pmo.subdivision = ( select gd.subdivision from gis_data gd where pmo.apn_9 = gd.apn); When I run it from SQL*Plus, it seems run forever and I can't get any results. Can someone give me some suggestions...

Hi, But DECODE will not work at OWB. You can use CASE instead. Regards Xuewei

Hi, I try to install workflow2.6.2 that comes with Oracle9iAS9.0.2 in Windows2000. There are Oracle9iAS9.0.2 infrastruture and Oracle9i Development Suite2.0.9.0.2 installed in the same computer. I always get error &quot;Error in writing to file c:\Program...

Hi, I have a question about data loading in Oracle Warehouse Builder(OWB). I have a very simple testing that only include one source table and one target table. I deploy the scripts and register the job in OEM. But, after I run the job, there are no data in the target table. There are no...

Hi, I have a question about data loading in Oracle Warehouse Builder(OWB). I have a very simple testing that only include one source table and one target table. I deploy the scripts and register the job in OEM. But, after I run the job, there are no data in the target table. There are no...

Good Morning Robert, Thank you! It works. Xuewei

Hi, I have a simple question. I have some Access Databases. I burned them to a CD-R. When I try to open them from the CD or even copy them to hard drive, the database always &quot;Read Only&quot;. I couldn't open the database. Please tell me why and how can solve this problem. Thanks Xuewei

Hi, I am trying to run a simple mapping to transfer data from one Oracle DB into another Oracle DB(Warehouse). There are not errors when I validate the mapping. But, I always get an error &quot;PL/SQL: ORA - 00942: table or view does not exit&quot; when I attempt to deploy my PLS scrip that...