|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
How to UPDATE in ROW-style?
Hello.
How could I write something like: DECLARE r table%RWTYPE; UPDATE table SET (table.*) = (SELECT r.*) WHERE id = r.id; *This *syntax is invalid, and I cannot find another proper way to do it without explicit enumeration of table's columns. I don't want to explicitly specify table's column to minimize later refactoring. P.S. The corresponding INSERT operator works fine: DECLARE r table%RWTYPE; INSERT INT table (SELECT r.*); Please say if a similar syntax for UPDATE exists. |
![]() |
| Viewing: Web Development Archives > Mailing Lists > Databases > How to UPDATE in ROW-style? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|