ThatJeffSmith blog is about tips and tricks for Oracle SQL Developer, SQLcl, SQL Developer Data Modeler, and Oracle REST Data Services. My primary goal is to help you save time when working with Oracle Database. If I can ALSO make what you’re currently doing a little more fun, then that’s a big bonus for me.
Today, I want to show you our CREATE and EDIT TABLE dialogs.
While I aim for 10 minute videos, I had to go into overtime, and came out at 13 minutes. But as a bonus, you get to see me think in real time as I cocktail-napkin-style ‘design’ my table.
But before I show the video, some people have been asking –
Where can I get and use SQL Developer Web!?!
The answer is of course, in the Oracle Cloud! Sign up for one of our DBaaS subscriptions. In the future: we will be adding this interface for many of our other database-centric services AND we will be making this available for on our on-premises Oracle Database customers (via ORDS.) So, stay tuned for more news in this space.
In other, shorter words, “SQL Developer Web is Cloud-First, not Cloud-Only.” — insert legalese and disclaimers here.
If you’re a subscriber to the blog – thank you! – and reading this post in your INBOX, you’ll need to open the post directly on my site, as the RSS feeds don’t render the embedded YouTube videos in many of your email clients. Or you can of course also subscribe and hit the notification button for my YouTube channel to know immediately when I post new content.
Oracle SQL Developer Web: CREATE and EDIT TABLEs - YouTube
Oracle SQL Developer Web: Demonstrating the Data Modeler - YouTube
This was my 50th post on YouTube. If you like what you see, be sure to subscribe there so you don’t miss any updates. Your subscriptions will also prove to my kids that I AM A REAL YOUTUBER. Well, probably not. But thanks anyway.
please, is it possible to define and save a (sub)set of objects for comparison? In Databasediff wizard we have an option to define objects, but it’s a bit cumbersome to do the same thing over and over again, so it would be highly useful to save options and selected items for comparison for future use.
Normally when someone asks me about ordering packages, I check the doorstop for our daily Amazon delivery. Ok, it just seems that way, and I’m lucky that my awesome wife/partner doesn’t read this blog…
…but what we’re really here to talk about is finding stuff in your PL/SQL package.
I think there are 2 types of folks:
Those that code willy-nilly: they build out each variable, procedure, type, function as it pops into their mind
Those that pretend they’re not in group 1
Unfortunately when it comes to browsing your PL/SQL, that well crafted package declaration comes back to bite you.
So what’s a developer to do?
Have it your way, right-click
One of these should work for you.
By default we show it the way the developer wanted you to see it – as it’s coded.
I think this one is probably the most logical way to go if you’re going to change things up.
Show me these things in alpha, then those things in alpha…
I’m right-clicking ON a package member to get this context menu, but it’s on the package itself as well, just with all the other things.
Happy Friday, folks!
If you want a fun package to test this with, then I suggest giving SYS.DBMS_METADATA a go.
This blog post was going to be JUST that picture above. The size of the logos show what I think are the importance, reach, or quality of their content. But I figured I should throw some words and numbers to go with it. You might now know this, but I’m a bit obsessed with Social Media. It’s worked for me, ...
Due to popular demand, we’ve added this new preference to the formatter. With it turned on: On SELECT B.DEPARTMENT_NAME, A.FIRST_NAME, A.LAST_NAME, A.SALARY FROM DEPARTMENTS B, EMPLOYEES A WHERE A.EMPLOYEE_ID = B.MANAGER_ID AND B.DEPARTMENT_ID (+) = A.DEPARTMENT_ID ORDER BY SALARY DESC, LAST_NAME ASC; Off SELECT B.DEPARTMENT_NAME, A.FIRST_NAME, A.LAST_NAME, A.SALARY FROM DEPARTMENTS B, EMPLOYEES A WHERE A.EMPLOYEE_ID = B.MANAGER_ID AND B.DEPARTMENT_ID (+) ...