Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 6315 Views
- I also Faced
- E-Mail Answers
Answer Posted / m.raghu
by using sub query answer is
update table1 set col1=(select col2 from table2 where
<cond>)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is the source code of a program?
how to calculate expressions with sql statements? : Sql dba
How do I run a query in pl sql developer?
What is scalar data type in pl sql?
Is a secondary key the same as a foreign key?
What is sql character function?
how to use 'mysql' to run sql statements? : Sql dba
What are the types of records?
Which table is left in join?
What is pessimistic concurrency control? : Transact sql
what is a foreign key ? : Sql dba
Explain the savepoint statement.
What is difference between sql function and stored procedure?
What is a boolean in sql?
