Is there an easy way to back up custom fragments of Oracle SQL Developer software?

Question

I like Oracle SQL Developer, so I use it a lot to complete my daily tasks. The fact is that my collection of custom snippets continues to grow, so although it would be interesting to know how to create them.

Before asking blindly, I took the trouble to figure out how to do this. I searched the application folder using "snippet" and found the following file:

oracle.sqldeveloper.snippet.jar 

which most likely contains my favorite code snippets. I could just save this file, hoping for the best, but why not do it right and maybe I could not, say, just create a backup, and I created, avoiding those that went out of the box, and Cetera?

Any suggestion would be really appreciated!

Answer 1

On my WinXP machine, I found my custom snippets at:

C:\Documents and Settings\eddie\Application Data\SQL Developer\UserSnippets.xml

PS: Replace eddie with your username.

Answer 2

Agreeing with Eddie Avad, just copy the xml file. And for windows7, the User-Snippets sqldeveloper file can be found here:

C: \ Users [username] \ AppData \ Roaming \ SQL Developer \ UserSnippets.xml

Answer 3

Do you work on Windows? Check your directory "C: \ Documents and Settings \\ Application Data \ SQL Developer" for the UserSnippets.xml file, it contains all the user fragments.

Also, see the online help for the "Locating user-related information" section. It has an arrangement of files in which other user data is stored.

-Dave

Answer 4

If you are using SQL Developer for Mac OS X, the snippets can be found in ~ / Library / Application Support / SQL Developer / UserSnippets.xml

Answer 5

Why not create a package on the Oracle server for daily maintenance so that it is stored in your database and in database backups?

EDIT: I do this and find it even easier to use them for common maintenance tasks. The ability to call a packaged procedure is really, REALLY convenient sometimes.

Answer 6

For SQL Developer 3.2.20.09 on OS X Mountain Lion (10.8. *), The fragment file is located in ~/.sqldeveloper/UserSnippets.xml .

Answer 7

In OS-X Yosemite (10.10.5) I found the current UserSnippets.xml for the current SQL developer (version 4.1.0.19) also in ~/.sqldeveloper/UserSnippets.xml

Answer 8

Agree with Spyder -

C: \ Users \ [username] \ AppData \ Roaming \ SQL Developer \ UserSnippets.xml

this place. But I found this only after creating my first new fragment.

After that, I was able to edit the XML to add new snippets and new categories. After making changes to xml, SQLDev should be restarted. (And since it's xml, I'll see if I can save it to Git to share with my team when I have a minute ...)