Excel-DB. Rapid Database Spreadsheet Analysis. Rapid Database Spreadsheet Analysis  

Excel-DB Help - Excel-DB Command Reference

There are a number of SQL*Plus like commands available in Excel-DB that are not part of standard SQL. To execute one or more of these commands please execute them through the SQL dialog. Note that you are allowed to mix these commands with other commands or SQL statements. Please find a list of supported commands below:

Excel-DB Command Reference

Command Description
@ Execute an sql file.
@@ Execute an sql file.
Accept Prompts for value of substitution variable.
Break Create report breaks.
Clear Removes formatting options.
Column Sets formatting options for columns.
Connect Connects to a database.
Define Define and manage substitution variables.
Describe Shows the description of a table.
Disconnect Disconnects from the database.
Execute Execute a SQL or PL/SQL statement
Exit Closes Excel-DB and Excel.
Help Displays the Excel-DB help file.
Host Executes an operating system command.
Pause Pauses execution.
Print Displays the value of a bind variable.
Prompt Displays a message.
Remark SQL Comments
Quit Closes Excel-DB and Excel.
Resultset_from_proc Outputs data from a stored procedure
Select As Comment Selects data into an excel comments
Select As Formula Selects data into an excel formulas
Select To Presets the target range for the result set
Set Sets program variables.
Show Shows the value of program variables.
Start Execute an sql file.
Timing Switches a statement timer on/off.
Undefine Undefines a substitution variable.
Variable Define and manage bind variables.


A Division of Rampant TechPress
P.O. Box 511 . Kittrell, NC . USA .

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.