Hotdin Gurning Hotdin Gurning 1, 2 2 gold badges 14 14 silver badges 24 24 bronze badges. Add a comment. Active Oldest Votes. This will work. Please check. Himanshu 4, 16 16 gold badges 28 28 silver badges 37 37 bronze badges. Anand Anand 46 1 1 bronze badge. Col1 as OLD1, Table2. Col1 as NEW1 Table1. Col2 as OLD2, Table2. Ganesh Ganesh 9, 1 1 gold badge 28 28 silver badges 48 48 bronze badges. RubahMalam if Destination tables are view then you can't update it — Ganesh.
Aman Khan Aman Khan 11 1 1 bronze badge. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. The Oracle update statement locates one or more rows or all the rows in a table and sets one or more columns to the specified values. As with the insert statement, the values must either match the columns data type or one that the database can implicitly convert.
The basic format is:. Here is a working example of an update against multiple columns and columns. This uodate changes two column and three rows:. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.
Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.
0コメント