Toad start-up Script

Save below script in c:\toad.startup.sql


BEGIN
INSERT INTO FND_SESSIONS
SELECT USERENV('SESSIONID'), TRUNC( SYSDATE )
FROM DUAL;
COMMIT;
END;
/
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO( 101 );
END;
/
BEGIN
FND_GLOBAL.SET_NLS_CONTEXT (P_NLS_LANGUAGE => 'AMERICAN');
COMMIT;
END;
/
---End of script


open toad then click on view-> Toad options->schema browser->Startup(As shown below)

click on apply and restart the toad, The above script files executed automatically and set to language and org information to your toad session.


If you want execute above script for every new connecton call same file in " File to execute on new connections: c:\toad_startup.sql "