Updating a table rows whose rows are same except for a few columns. For example all the rows are same except for insert datetime or status like columns.
UPDATE schema1.table1 a
SET col4 = 'ABC'
WHERE a.col3 <
ANY (SELECT b.col3
FROM schema1.table1 b
WHERE a.col1 = b.col1
and a.col2=b.col2);
You can see update results by:
SELECT col1,col2,col3,col4 from schema1.table1 where col1||col2 in (
SELECT col1||col2
FROM schema1.table1
group by col1,col2
having count(*)>1)
Subscribe to:
Post Comments (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
-
Simple but very handy way of taking exports without knowing database password. expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFIL...
-
It seems an easy topic, I prefer being careful with the easy ones... so it is handy to have all you need, in one place and which will lead i...
-
This directory is created in the home directory of the oracle user, after making a local connection. I had tested it as follows: [oracle@geo...
No comments:
Post a Comment