Expressions

An expression specifies a value.

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram   .-operator-------------------------.
   V                                  |
>>---+-----+--+-function------------+-+------------------------><
     +- + -+  +-(expression)--------+
     '- - -'  +-constant------------+
              +-column-name---------+
              +-variable------------+
              +-special-register----+
              +-(scalar-fullselect)-+
              +-labeled-duration----+
              +-case-expression-----+
              +-cast-specification--+
              +-OLAP-specification--+
              '-sequence-reference--'
 

operator:

Read syntax diagramSkip visual syntax diagram>>-+-CONCAT-+--------------------------------------------------><
   +- || ----+
   +- / ----+
   +- * ----+
   +- ** ---+
   +- + ----+
   '- - ----'
 

labeled-duration:

Read syntax diagramSkip visual syntax diagram>>-+-function-----+--+-YEAR---------+--------------------------><
   +-(expression)-+  +-YEARS--------+
   +-constant-----+  +-MONTH--------+
   +-column-name--+  +-MONTHS-------+
   '-variable-----'  +-DAY----------+
                     +-DAYS---------+
                     +-HOUR---------+
                     +-HOURS--------+
                     +-MINUTE-------+
                     +-MINUTES------+
                     +-SECOND-------+
                     +-SECONDS------+
                     +-MICROSECOND--+
                     '-MICROSECONDS-'