Start Pl sql updating multiple columns

Pl sql updating multiple columns

UPDATE table SET (col1,col2) =3D (SELECT col3,col4 FROM table2 WHERE table1=3Dtable2.id) Martin -----Urspr=FCngliche Nachricht-----" id="ctl00_m_m_i_ctl00_gr_ctl07_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="525332" // from empupd a , emp b * ERROR at line 4: ORA-00933: SQL command not properly ended Elapsed: .00 Thanks Regards Ajay K. Centre Dell International Services Bangalore, India Austin Dial-in : 753-78897 Phone : (080) 28077665 Cell : (0) 9886623796" id="ctl00_m_m_i_ctl00_gr_ctl09_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="525334" // from empupd a , emp b * ERROR at line 4: ORA-00933: SQL command not properly ended Elapsed: .00 Thanks Regards Ajay K.

Whenever you alter the value of a column referenced by the -- All the employees except the manager of -- department (WORKDEPT) 'E21' have been temporarily reassigned.

-- Indicate this by changing their job (JOB) to NULL and their pay -- (SALARY, BONUS, COMM) values to zero in the EMPLOYEE table.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions.

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hii Alll Is it possible to update multiple column based on case statement??

Dropping an alias invalidates a prepared update statement if the latter statement uses the alias.

Dropping or adding triggers on the target table of the update invalidates the update statement.

Specifying DEFAULT for the update value sets the value of the column to the default defined for that table.