I can run the below script with the @@in SQL*Plus, but when running it in Toad for Oracle I get the following error:
ORA-02083: database name has illegal character .
select
dvp,
rd,
store_number
@@test2.sql
FROM
final_ptw_bottom_10_pct_list
where
week_end_date between 19-SEP-09 and TO_DATE(NEXT_DAY(SYSDATE-7,saturday),DD-MM-RRRR)
group by
dvp,
rd,
store_number;
From Toad Help, it states the @ and @@ are SQL*Plus commands supported by Toad for Oracle.
WORKAROUND:
None
STATUS:
Enhancement request ER# ST68043 has been submitted to Development for consideration in a future release of Toad for Oracle.
