It is not possible to use RECNO as an alias.
This works in Toad 9.7 and in SQL Plus but in Toad 10 it fails.
Steps to reproduce the problem:
1] Open up the editor in Toad For Oracle 10.0
2] Paste in the following sql:
select 1 as recno
from dual;
3] Run as a SCRIPT ( ie press F5 ). The error "mData1: Duplicate field name 'RecNo'" appears
4] Run the same select as a STATEMENT ( ie press F9 ) then the error "Duplicate field name 'RecNo'" appears
WORKAROUND:
Use another word as alias
STATUS:
Waiting for fix in a future release of Toad For Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center