SQL*XL: Excel functions

Excel Functions

SQL*XL
home

A few SQL*XL functions are available as Excel worksheet functions. These can be typed in an Excel cell and the result is displayed just as a normal Excel function would do. To create an SQL*XL Excel function select the function from the Insert Function menu of SQL*XL.

The following SQL*XL Excel functions are available:

Command Description

SQLBindVariable Display the value of a database bind variable.

SQLCreateDeleteStatement Create an SQL delete statement.

SQLCreateInsertStatement Create an SQL insert statement.

SQLCreateUpdateStatement Create an SQL update statement.

SQLFunction Execute a database function and display the result.

SQLQueryValue Executes a select statement and display the result.

SQLSubstitutionVariable Display the value of a database substitution variable.

Command	Description
SQLBindVariable	Display the value of a database bind variable.
SQLCreateDeleteStatement	Create an SQL delete statement.
SQLCreateInsertStatement	Create an SQL insert statement.
SQLCreateUpdateStatement	Create an SQL update statement.
SQLFunction	Execute a database function and display the result.
SQLQueryValue	Executes a select statement and display the result.
SQLSubstitutionVariable	Display the value of a database substitution variable.