select 'Quest'||chr(9)||'Support' name from dual
Exporting dataset using INSERT statement results in:
Insert into DUAL
(NAME)
Values
('Quest Support');
i.e. it replaces the tab with spaces. This is currently controlled by option:
View | Toad Options | Editor | Tabs | Mode - 'Use Spaces'
Want 'data export' to maintain tabs in INSERT statements regardless of the Editor option.
WORKAROUND
iF 'Use Spaces' is required in the editor, then temporarily change the following option
View | Toad Options | Editor | Tabs | Mode - 'Use Tabs'
Once export is complete revert the setting to 'Use Spaces'
STATUS
Enhancement request ER#646 has been submitted to Development for consideration in a future release of Toad for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
