UPDATE (SELECT t1.col1 c1, t2.col1 c2 FROM table1 t1, table2 t2

how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
executed query

Question Posted / mglbayar

3 Answers
6487 Views
I also Faced
E-Mail Answers

Answer Posted / mglbayar

UPDATE (SELECT t1.col1 c1, t2.col1 c2
FROM table1 t1, table2 t2
WHERE t1.pk = t2.fk AND more_condition)
SET c1 = c2;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does the argument [or replace] do?

1098

What is composite data type in pl sql?

1124

Which query operators in sql is used for pattern matching?

981

what are tables and fields? : Sql dba

1067

how to shut down the server with 'mysqladmin'? : Sql dba

1023

What is a delimiter in sas?

1065

What are the two characteristics of a primary key?

996

what is try_catch block in procedure

1760

What is trigger with example?

1111

Explain mutating table error.

1214

What is a dirty read sql?

1169

What is a primary key sql?

1051

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1588

How does an execution block start and end in pl sql?

959

What is the best free sql database?

1063