ThatJeffSmith

Tag: export

SQL Developer: Preferences for Delimited Text Exports

Yes, it’s true. Some people export their data to formats other than Excel. Another popular format is ‘delimited,’ where fields are defined by a delimiter. The most famous of these is CSV, a comma separated values file. So your data can be read by another program quite easily because it knows where one field stops [...]

File Logging with SQL Developer v3.1

I’m lazy. If I can drive a screw with my cordless drill in 5 seconds vs 60 seconds, but have to walk to the garage to get it, I’ll pick the drill over the screwdriver every time. Probably because after I’m finished with that screw, my foreman will walk over and decide she wants the [...]

Introducing the SQL Developer ‘Shopping’ Cart

Just in time for the upcoming holiday shopping season, SQL Developer v3.1 (now available as an Early Adopter release), allows the developer or DBA to build ad-hoc deployment scripts. Need to ‘order’ that list of objects and underlying data for your test environment? Just add them to your cart and you’re ready for check-out! Once [...]

Three (4) Ways to get Data into Excel with Toad

I have been really hard on Excel lately. Excel is an excellent tool. Tools can be misused and abused, but it’s not their fault. I should know this being an advocate for Toad, but I digress. Updated on 1/5/2011 to include 4th Method and add note on ‘Display all results in grid’ option. You want [...]