SQL Developer Database Diff – Compare Objects From Multiple Schemas

thatjeffsmith SQL Developer 76 Comments

Ever wonder why Database Diff isn’t called Schema Diff? One reason is because SQL Developer actually allows you to select objects from more than one schema in the ‘Source’ connection for compares. Now, before you get around to testing this – as you should never believe what I say, trust but verify – two things you need to know: I’m …

SQL Developer does XML

thatjeffsmith SQL Developer 21 Comments

If you’re looking for insight or guidance on XML, XML in the database, or XMLDB – then please keep looking. I have not much to add here. What I am here to talk about is some of the support that SQL Developer offers for XML in the database. You may have heard me say ‘I do not like XML.’ What …

SQL Developer Quick Hit: Split and Side-by-Side Editors

thatjeffsmith Database Stuff, SQL Developer 6 Comments

Want multiple scratch pads for your queries? Have a hundred+ line stored procedure? Then here are two tips for you! Side-by-Side Worksheets To get started you’ll need at least two worksheets open. So something like this Next, you can either click and drag the 2nd worksheet tab to the right or underneath. If you drag right you will get something …