Here’s an 8 minute video walk through of using INFO and DESC in Oracle SQLcl. You can decide what works better for you – hey, maybe you’ll decide to use both! INFO shows more info INFO+ shows more info with more stats You can INFO a package OR a package.procedure Enjoy! PS – I made this on my new rig …
How Do I Get My Charts Out of a Report?
Someone asked, I have this cool report, how do I get the chart out of it? For now I’ve been taking screenshots. So let’s look at how you can get your Report out to HTML (and a PNG.) When I say HTML, I mean you have a SQL Dev report that’s generated by SQL Developer itself. I am NOT talking …
Shopping for CSV with SQL Developer’s Cart
A friend of mine asked how he could generate CSV for 40 Oracle tables in Oracle SQL Developer. He could of course use Tools > Database Export to accomplish this. But, it was always the same 40 tables. And using the object picker in the wizard can get tedious, especially if it’s the same 40 tables every day/week/month/epoch. So, I …
Batch Loading Your Oracle Database Cloud Services via the SQL Developer Command-Line Interface
I recently talked about how to load up your Oracle Cloud service with your local data. In that scenario, you’re in the graphical user interface, clicking buttons, doing things more ad-hoc. But what if you wanted to build an automated process to load up data from an on-premise Oracle Database? You won’t have a GUI available then, so what’s available? …
Oracle SQL Developer Meets SQL*Plus?
If you weren’t paying attention over the Christmas/Winter break, it’s very possible that you haven’t heard about our new project. You can find it on the SQL Developer version 4.1 Early Adopter download page.. If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just watch the movie. In ten …