H2 Database – Call CALL is a SQL command which belongs to H2 database server. This command is used to calculate a simple expression. It returns the result of the given expression in a single column field. When it returns an array of results, then each element in the array is displayed as a column […]
Author Archives: user
H2 Database – Insert The SQL INSERT statement is used to add new rows of data to a table in the database. Syntax Following is the basic syntax of INSERT INTO statement. INSERT INTO tableName { [ ( columnName [,…] ) ] { VALUES { ( { DEFAULT | expression } [,…] ) } [,…] […]
H2 Database – Explain EXPLAIN command displays the execution plan for a statement. When we execute a statement using EXPLAIN ANALYZE command, the query plan will include the actual row scan count for each table. Syntax Following is the generic syntax of the EXPLAIN command. EXPLAIN { [ PLAN FOR ] | ANALYZE } { […]