SQL Language (MOSC)

MOSC Banner

How to update multiple columns with single select query

edited Mar 24, 2017 3:59AM in SQL Language (MOSC) 11 commentsAnswered ✓

I want to update few columns of a row with few columns of another row. Is there any way to do it with update with single query.

e.g.

tabale : Empl

empno salary level department

I want to write an update statement that updates salary and level of an employee whose empno is x,  with salary and level of employee with empno y.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center