The VALUES clause is used to insert a small amount of temporary data into a table for query and analysis. This topic describes the syntax of the VALUES clause. This topic also provides examples on how to use the VALUES clause.


VALUES(column_value01, column_value02...) table_name(column_name01,column_name02...)


Parameter Description
column_value The values that you want to insert into the column. You can specify constants, expressions, or functions.
table_name The name of the table into which you want to insert the values.
column_name The name of the column into which you want to insert the values.


Use the VALUES clause to insert data into a column named pv in the table named access.

  • Query statement
    * |
    FROM  (
      ) AS access(pv)
  • Query and analysis resultsvalues