Updating one table from another

posted by | Leave a comment

I am using Table T1 to insert or update the data inthe Table T2 (which has a unique key column -c1 c2) in oracle 8.1.7. COM merge into t1 2 using t2 3 on ( t2.object_id = t1.object_id ) 4 when matched then 5 update set t1.object_name = t2.object_name 6 when not matched then 7 insert (object_id, object_name) values( t2.object_id, t2.object_name); 29317 rows merged. In my case Table T1 (staging table with 300 columns) will have 200 thousand rows every day for insert or update to the history table T2 ( 280 columns) that has 10 Million historical rows. For this I am using another table to find previous year dates for current year dates.

updating one table from another-87

That will help me decide if the method I am considering explaining to you is likely to work.I put a primary key on B(id) because if there is NO SUCH constraint -- the update is totally ambigous -- if there is more then 1 value of B1 in B for a given ID -- we cannot tell what row in B should be used to update the row in A. REGISTRATION where BIN NOT IN (select BIN from VIS. Its working very nicely.i will greateful to u forever.i was suffering by this problem for a long i am using the following / insert into VISTEMP. i could envision problems with only a second of granularity on a clock -- you could miss a record or two due to that. d) I don't program forms -- you can try otn.- Thank u very much for ur nice reply. I plan to use RTRIM function in the WHERE clause to get specific set records and then after fetching, I’ll insert with a RTRIM on each column.Given that, we can: [email protected] select * from a 2 / ID A1 ---------- ------------------------- 1 Hello 2 World The following updates are equivalent as well - they do the same thing differently. REGISTRATION); RUN and Computer in BIG Busy mood(Hang). REGISTRATION(BIN, NAME, NAME_ALIAS, COR_GROUP, AUTHOBY, AUTHODATE, CG_NAME, ADD1, ADD2, ADD3, TEL1, FAX1, ADD5, ADD6, ADD7, TEL2, FAX2, ADD9, ADD10, ADD11, TEL3, FAX3, TP_TYPE, TRD_LINC, TRD_FY, TRD_AUTH, IMP_REG, EXP_REG, REG_TYPE, TIN, STATUS, PRE_BIN, DATREG, STAT_CHNG, ACT_CODE, ACT_MULT, ITEM_TYPE, OLD_ACT, APP_CAT, LCODE, ISSUE_DATE, VREG, M_POSI, MFUNC, SFUNC, LAST_USER, LAST_ACCS, TREG, PAY_FREQ, CREG, EREG, OREG, OP_BAL, OP_BAL_DT)select BIN, NAME, NAME_ALIAS,---- from VIS. In update portion i am facing another problem by ur recomended code. INSERT into abc values (RTRIM(col1), RTRIM(col2) .) There is another option where I can use SELECT RTRIM(col1), RTRIM(col2) from xxx where RTRIM(col1) = ‘yyy’ and then directly use insert into target table without RTRIM. When the Show Table window appears, select the tables that you wish to use in the query and click on the Add button.You can select multiple tables by holding down the Update Query from the popup menu.

Leave a Reply

  1. apol saspa dating 09-Mar-2017 13:44

    It takes a little work, but the girls over here are a lot more sexual than the college coeds we’re used to banging in the USA.

  2. ha ji won dating hyun bin 24-Sep-2017 11:29

    With a commitment to connecting black singles worldwide, we bring to you a safe and easy platform designed to help you meet your love match.

  3. Ladyboy chat no registry 24-Jul-2017 17:05

    I'm here to take the hassle and guesswork out of finding the right adult webcam sex site for each and every sexcam visitor.

  4. Sex chat without register with mom 28-Feb-2018 14:50

    Why get bogged down with inconvenient registration pages when you don’t have to?

  5. strong dating site in asia 23-Aug-2017 13:26

    Cons: After sending someone a message, you're notified when they're checking your profile, which means you can actually see yourself being rejected in real time.

biblical view of carbon dating