Literal Row

The syntax for a literal representation of the value of a named or unnamed ROW data type is described in the section Literal Row. The following examples show literal rows as expressions:

INSERT INTO employee VALUES 
   (ROW('103 Baker St', 'San Francisco', 
      'CA', 94500));

UPDATE rectangles
   SET rect = ROW(8, 3, 7, 20)
   WHERE area = 140;

EXEC SQL update table(:a_row) 
   set x=0, y=0, length=10, width=20;

SELECT row_col FROM tab_b
   WHERE ROW(17, 'abc') IN (row_col);