Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The solution that I give you works, <strong>IF AND ONLY IF</strong>, the column <strong>cycle_id</strong> is the <strong>primary key</strong> of your table.</p> <pre><code>UPDATE pl_updatetest t1 SET t1.extract_date = ( SELECT t2.extract_date FROM pl_updatetest t2 WHERE t1.cycle_id = t2.cycle_id + 1 ) WHERE t1.cycle_id &lt;&gt; (SELECT MIN(cycle_id) FROM pl_updatetest); </code></pre> <p>Here is a test cast indicating how this query can be used to change your table.</p> <pre><code>DROP TABLE pl_updatetest; CREATE TABLE pl_updatetest ( cycle_id NUMBER NOT NULL, extract_date DATE NOT NULL ); ALTER TABLE pl_updatetest ADD CONSTRAINT PK_PL_UPDATETEST PRIMARY KEY(cycle_id); INSERT ALL INTO pl_updatetest(cycle_id, extract_date) VALUES(100, TO_DATE('01-JAN-2012', 'DD-MON-YYYY')) INTO pl_updatetest(cycle_id, extract_date) VALUES(101, TO_DATE('02-JAN-2012', 'DD-MON-YYYY')) INTO pl_updatetest(cycle_id, extract_date) VALUES(102, TO_DATE('03-JAN-2012', 'DD-MON-YYYY')) INTO pl_updatetest(cycle_id, extract_date) VALUES(103, TO_DATE('04-JAN-2012', 'DD-MON-YYYY')) INTO pl_updatetest(cycle_id, extract_date) VALUES(104, TO_DATE('05-JAN-2012', 'DD-MON-YYYY')) INTO pl_updatetest(cycle_id, extract_date) VALUES(105, TO_DATE('06-JAN-2012', 'DD-MON-YYYY')) SELECT * FROM DUAL; Table dropped. Table created. Table altered. 6 rows created. SQL&gt; SELECT * FROM pl_updatetest; CYCLE_ID EXTRACT_D ---------- --------- 100 01-JAN-12 101 02-JAN-12 102 03-JAN-12 103 04-JAN-12 104 05-JAN-12 105 06-JAN-12 6 rows selected. SQL&gt; UPDATE pl_updatetest t1 SET t1.extract_date = ( SELECT t2.extract_date FROM pl_updatetest t2 WHERE t1.cycle_id = t2.cycle_id + 1 ) WHERE t1.cycle_id &lt;&gt; (SELECT MIN(cycle_id) FROM pl_updatetest); 5 rows updated. SQL&gt; SQL&gt; SQL&gt; SELECT * FROM pl_updatetest; CYCLE_ID EXTRACT_D ---------- ----------- 100 01-JAN-12 101 01-JAN-12 102 02-JAN-12 103 03-JAN-12 104 04-JAN-12 105 05-JAN-12 6 rows selected. SQL&gt; </code></pre> <p>Regards</p> <p>Dariyoosh</p>
    singulars
    1. This table or related slice is empty.
    1. POOracle PL/SQL script optimization for setting one record value to another
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USdariyoosh
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POOracle PL/SQL script optimization for setting one record value to another
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COIt's not quite as simple as you make out, you've assumed that thePK is an incrementing integer with no gaps. It's highly unlikely that this is the case...
      singulars
      1. PO
      1. USBen
    2. COIt doesn't appear to be changing anything in the table I'm using. I can't pinpoint the logic but it said all 120 rows updated but I'm not seeing any difference.
      singulars
      1. PO
      1. USGeoff Dawdy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload