Here’s how to format your sql and plsql code from the command line using Oracle SQLcl.
Since SQLcl is a command line tool, it’s not super helpful to have a huge command history list. How do I mean? Well, in the SQL Developer GUI, we have a History panel. It allows for sorting, filtering, scrolling, etc. So you can go ‘crazy’ and set your History limit to 1000 if you want. But, in SQLcl, we limit the user to their last 100 commands. Now there are many commands you’ll be running…
Updated 25 May 2022 This is formerly a trick. We made this just a simple action of opening the User and going to the SQL panel in the DBA, Security section. If this isn’t working for you, it’s because you’re on an older version of SQL Developer…in which case, read on. The Trick, if you’re on an older copy of SQLDev This challenge has come up a few times recently for me. Just HOW can…
I went to link to this post earlier today, and was shocked to discover I hadn’t actually written it yet. What’s the opposite of ‘bazinga!’ ? SQL Developer stores every query AND script you execute in a worksheet. A query being a single statement, and a script being one or more queries and/or anonymous blocks. A query is stored as a single item. A ‘script’ is stored as a single item. By DEFAULT, we store…
The Connection Tree and Schema Browser make pretty nifty object navigators. But maybe you want your own custom list of objects. Perhaps you’re working on a project and you only want to see objects that pertain to Project XYZ. And you’re able to ID these objects by a common column ID – or use your imagination and think of some other meta bit or byte. It could look a little something like this: I simply…
This might sound preachy, but it’s mostly not intentional, mostly. You might really enjoy the flexibility of the PL/SQL APIs the database provides for things like Resource management, the Scheduler, Data Pump. You might even have memorized the PL/SQL function/proc names and arguments required to create a job, or change up a resource. But do you really want to spend that much time typing? So. While I can show DBAs, over and over again, how…
Remember back when Corel first released WordPerfect? Remember how it had like a bazillion keyboard shortcuts, and you needed help remembering them all? No? You probably also don’t remember a world sans e-mail and smart phones either. Oh well. Anyways, we have lots of keyboard shortcuts in SQL Developer and a few in SQLcl. You might need help remembering them. Cue the ‘nerd stick.’ Or at least that’s what I’ve always called these. Maybe I’ll…
Yeah, we support RAC. Note, we did fix quite a few RAC related bugs in the 4.1.1 update. These screenshots were taken with version 4.1.2. When you want to look at historical data in ASH or AWR, you’ll have to specify the Instance number to pull the report from. And the report… Or if you want to browse sessions… You can of course filter on any column in the Monitor Sessions page. To see only…
This has been around for a loooooong time. But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling. Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to PAUSE. SET PAUSE ON [DOCS] in sql*plus allows a script to ‘pause’ until you hit ‘ENTER’ for it to continue.…
A question came up on the oracle-l… I am working in SQL developer 4.0. I am comparing my acceptance version of a schema to my production version of the same schema. We did some ‘clean-up’ of old tables and views in acceptance. We want to apply the same changes to production, when we go to prod. How do I tell SQL D to produce a ‘drop’ statement when running a diff and doing the compare?…