I have added this line of code at the beginning of my SQL
alter session set "_fix_control"='17376322:OFF';
to fix error - ORA-01792 (Maximum number of columns in a table or view is 1000.
The problem is that I am not running this in SQL Plus nor SQL developer but via Excel through ODBC connection.
I get this error : *[Oracle][ODBC][Ora]ORA-00922: missing or invalid option*
Can someone please tell me how I can add this alter session command to supress the ORA-01792 when I run this via excel connection to the database.
Many thanks for your help.