When using "Export Data as Insert Statements" in the schema browser toolbar in the Table tab (left side), the script created if formatted for multiple lines (Toad 9)...
ex:
Insert into A_HUNDRED
(AKEY, AINT, ASIGNED, ADOUBLE, ACODE,
AADDRESS, ATIMESTAMP)
Values
(0, 59005902, 112, 979797980, 'iMZbYVqXdL',
'fEUfaN', TO_TIMESTAMP('4/4/2008 10:17:23.000000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'));
.... instead of 2 lines (as it is in Toad 8)...
ex:
Insert into A_HUNDRED (AKEY, AINT, ASIGNED, ADOUBLE, ACODE, AADDRESS, ATIMESTAMP)
Values (0, 59005902, 112, 979797980, 'iMZbYVqXdL', 'fEUfaN', TO_TIMESTAMP('4/4/2008 10:17:23.000000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'));
Is there a way of formatting the created insert script as 2 lines as what it was like in 8.0?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center