Hi Can anyone using schema select extension with sql developer 4.0+,If yes please help me .
What 'schema select extension' are you taking about?
Sql Dev 4 uses a new architecture to extensions written for previous versions will NOT work without modification. You need to contact the extension vendor, or their website, to see if they have modified their extension for sql dev 4.
Recently i migrated from Toad to Sql developer due to licensing issue ,but not firing alter session for each schema every time is pain .
I have no idea what that even means.
Why do you need to do an 'alter session for each schema' every time?
In addition to rp0428's comments, the 4.0 release notes in the Third Party Extensions section
indicates the extension developer will need update the extension for 4.0.
Also, since any given extension may not be in widespread use, we recommend providing a link to the extension, either from the source...
or our Extensions Exchange
As a workaround, see Jeff Smith's comment about triggers here
SQL Developer Team