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

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 Commands

Buy now

Download now

SQL*XL online help
 

SQL*XL: Select As Comment command

Select As Comment command

SQL*XL
home

Syntax:
SELECT column AS COMMENT FROM ...

Description:
Selects data into an Excel comment. It is important that the column prior to the column that is fetched As Comment is retrieved normally.

Examples of correct statements:
select ename, empno as comment from emp;
select empno, ename as comment, sal, hiredate, deptno as comment from emp;

Examples of incorrect statements:
select ename as comment from emp;
select empno, ename as comment, deptno as comment from emp;

See also:

SQL*XL ribbon in Excel