Specifies whether SQL*XL should take the SQL read from the worksheet as 1 statement or that each cell's contents
should be regarded as a single statement.
You can e.g. use multiple cells to define a command. You may also use Excel formulae to make SQL. SQL*XL will
only take the formula result.
Example:
If you have the following spreadsheet you may want to let SQL*XL treat all cells as one statement
A
B
C
D
1
select
*
from
2
emp
3
where
empno=
4
4
When you have the following spreadsheet you may want to let SQL*XL teat all cells as a statement:
Copyright (C) 1995-2007 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