H2 Database Tutorial
H2 Database - Data Manipulation
H2 Database - Data Definition
H2 Database Useful Resources
Selected Reading
H2 Database - Data Manipulation
- H2 Database - Show
- H2 Database - Merge
- H2 Database - Explain
- H2 Database - Call
- H2 Database - Backup
- H2 Database - Delete
- H2 Database - Update
- H2 Database - Insert
- H2 Database - Select
H2 Database - Data Definition
- H2 Database - JDBC Connection
- H2 Database - Rollback
- H2 Database - Savepoint
- H2 Database - Grant
- H2 Database - Commit
- H2 Database - Truncate
- H2 Database - Drop
- H2 Database - Alter
- H2 Database - Create
H2 Database Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
H2 Database - Call
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 value.
Syntax
Following is the generic syntax of the CALL command.
CALL expression;
We can use the arithmetic expression in this syntax.
Example
Let us take an example and execute an arithmetic expression (15 * 25) using call command.
CALL 15*25;
The above command produces the following output.
| 375 |
|---|
| 375 |