datingspeed com - Updating two tables in a single query in sql

In this article, we are going to look at four scenarios for Oracle cross table update. Category_ID) where exists ( select * from Categories b where b. These columns uniquely identify a record in a table.

Suppose we have two tables Categories and Categories_Test. The common column in the two tables is CATEGORY_ID. Please note that query below is used for illustration purpose because Category_ID alone is primary key.

Post ID=2669779&Site ID=1I'm not sure what you mean.

updating two tables in a single query in sql-85updating two tables in a single query in sql-83

I tried to update the tables in that view and I get the error. Seeing all the records in the view where unit 71054 I tried the update without the where cause all the records was that unitupdate tmp_mfg_unit_2set t_cmnf='OTH'and still the same error UNION ALL view 'tmp_mfg_unit_2' is not updatable because the definition contains a disallowed construct. I deleted the declare and added '71054' to parts of the the view works perfectly.

I tried to update the tables in that view and I get the error. All the records in the view was of unit 71054 I tried the update without the where clause.update tmp_mfg_unit_2set t_cmnf='OTH'and still the same error UNION ALL view 'tmp_mfg_unit_2' is not updatable because the definition contains a disallowed construct.

Should any right be infringed, it is totally unintentional.

Drop me an email and I will promptly and gladly rectify it.

There are 2 syntaxes for an update query in Oracle depending on whether you are performing a traditional update or updating one table with data from another table.

You can also perform more complicated updates in Oracle.

Card Gunner I didn't put all the tables in the code. I'll have to see if '71054' can be called as a parameter in VS 2003.

Can you do this type of statement when creating a view? Card Gunner Originally posted by jimf Found this trivia on the net a while ago DECLARE @Table A TABLE (i INT)DECLARE @Table B TABLE (i INT)SELECT * FROM @Table ASELECT * FROM @Table BINSERT @Table AOUTPUT inserted.i INTO @Table BSELECT 1 UNION ALLSELECT 2 UNION ALLSELECT 3SELECT * FROM @Table ASELECT * FROM @Table BOriginally posted by cardgunner I was afraid of that.

I never used it, so I don't have practical experience.

Now I know I had it wrong in my head all the time .

The only way to update multiple tables in a single statement is when you create a view over these tables and use the option WITH SCHEMABINDING.

Tags: , ,