I cannot find mention of this anywhere else. Over time, I have developed a habit of opening multiple instances of SQL Developer on my desktop machine. This generally happens because I'm working on multiple projects or responsibilities at the same time and discovered at some point that unless I *close* a worksheet, it will be there the next time I open SQL Developer. Entropy says to leave it where it is rather than re-open a series every day. I have also discovered that if I open multiple instances of SQL Developer, each instance contains a different set of worksheets.
For example:
The first instance of SQL Developer I open contains my standard daily data checks, the scripts that compare counts and sums for tables in different instances and the scripts that I use for troubleshooting when things don't match as expected.
The second instance of SQL Developer contains worksheets related to the exploration of a logic issue in our ETL code
The third instance contains worksheets related to the reconciliation of several reports and views that should tie but as of now do not
The fourth instance contains worksheets related to some other current assignments or background tasks
I generally do not go beyond four instances but I suppose that I could in theory.
My question is this. Rather than counting the number of instances to open to get to a certain set of worksheets (and opening unnecessary instances in the process), is there a way to create shortcuts for those environments ...
I know that SQL Developer is saving information related to formatting, what tabs are loaded and open and any of a number of other factors behind the scenes but SQLDeveloper.exe (or whatever it calls itself) is a single 'entity' ... so it seems to me that there may be a way to pass an identifier to the desired environment when opening SQLDeveloper.
For example: sqldeveloper64W -myDailyQCChecksAndCompares
sqldeveloper64W -myExplorationOfORGN_EOYAssignments
sqldeveloper64W -myReconcilationOfFIMSAndFORG
If anyone has suggestions I would love to hear them!
Thank you
--wb (Wendy) ( since I can't figure how to change myself from user#### to anything else)