Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help need with Update statement -- Efficient way

user13115886Oct 20 2020 — edited Nov 1 2020

Hi,
COl1 COl2
---- ----
A123 IPX
A123 IPY
A123 IPZ
A123 NULL
B123 IPY
B123 IPZ
B123 NULL
C123 IPZ
C123 NULL

if col2 has IPX, Would like to update all rows with IPX
if col2 has IPY, would like to update all rows with IPY -- A123 IPY is alrdy updated with IPX from the above condition
if col2 has IPZ, would like to update all rows with IPZ -- B123 IPZ is alrdy updated with IPY from the second condition

Best way to write the update statement by keeping all in one single statement, instead of writing three separate update statements.
Please advise.

Thanks

Comments

312396
Hi, Dominic. Your question of whether you should use Oracle Help for Java (OHJ) or Oracle Help for the Web (OHW) is answered by another question that you can hopefully answer yourself. If you want the help content to be installed on the client's machine, then you're best off using OHJ. If you'd like to host the help content on the server, then you ought to use OHW. The great thing about Oracle Help Technologies is that even if you commit to using one of our help systems, you can easily switch over to the other since we use the same help control files for both systems.

You can find out more about Oracle Help by reading the Oracle Help Guide at
http://otn.oracle.com/docs/tech/java/help/htdocs/ohguide/ohg_toc.html

You can deploy OHJ with any Java-based application, and OHW just needs a web browser.

To download OHJ and OHW (they are both free), go to
http://otn.oracle.com/software/tech/java/help/content.html

Hope this helps,
Ryan
1 - 1

Post Details

Added on Oct 20 2020
1 comment
110 views