Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
 

Software categories:
SQL*XL help
First Use
Features
Advanced
Commands
Dialogs
Menu & Toolbar
Excel Functions
Trouble Shooting
VBA & Macros
SQL*XL
Key Features
Usage
Editions
Customers
Forums
Help
Links
Download
Order

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Functions

Buy now

Download now
SQL*XL online help
 

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.

See also:

SQL*XL ribbon in Excel

Copyright (C) 1995-2010 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap