Loading...

In two previous posts, I have:

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.

The Demo!

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

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Not able to make my Tips & Tricks talk at the Great Lakes Oracle User Group conference this week?

Don’t have the 50 minutes to watch my recorded YouTube version?

Can you spare 90 seconds?

You don’t even need to turn the sound on.

Just watch this GIF.

5 or 6 tricks, in a single GIF!

To recap:

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In this 10 minute video, you get:

  • super quick recap of the Worksheet
  • building a new diagram
  • moving stuff around, changing the colors
  • generating DDL
  • generating a data dictionary report
  • saving and searching diagrams

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.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

We are now live in the Oracle Cloud with Oracle SQL Developer Web.

Wait, what’s SQL Developer Web?

It’s a browser based version of Oracle SQL Developer powered by Oracle REST Data Services.

If you are a Database Cloud Service customer in the Oracle Cloud, it’s rolling out now to those subscribers.

If you’d like to know more and see a quick demo, I made you a video

Announcing Oracle SQL Developer Web! - YouTube

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Someone asked, hey, I know how to hide the schema notation in our diagrams

You can too – READ THIS POST

…but (there is always a BUT), how can we hide it from the data dictionary reports as well?

The answer is – you need to manage the report template.

When you open the Report dialog, switch to the Custom Templates.

Click the ‘Manage’ button.

We give you two custom templates to play with, ‘Table_one_level_list_Props’ and ‘Tables_2_Levels’.

Pick one.

Click the Edit button.

This button.

Cool.

Now, you’re going to see a lot of properties. The first one on both the ‘Columns’ and ‘PK, UKs, and Indexes’ tables has a property name of ‘Schema Object.’

Remove that from the report property by using the Left arrow button, and save the report design.

Remove, save, run report using this custom template.

Once you’re back to the Reports dialog, make sure the right Custom Reports template is assigned and generate the report.

Voila, no mention of a SCHEMA, anywhere.

This isn’t a schema-less design…that’s…DIFFERENT.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

A question from the innerwebs –

Hello,

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.

Thanks a lot,

The answer is, Yes!

We have a nice Oracle By Example on this topic available here.

Use the Cart!

Define the objects to be used for the compare using Cart. Find them in your target database. Drag them to a cart.

Open the Cart.

I’m going to add 3 TABLES from HR.

Now I’m going to invoke the DIFF using the DIFF button on the Cart toolbar.

I need to pick my HR_COPY connection for the Destination Connection.

I need to change my CONNECTION to the Target Instance (HR_COPY) and click ‘Apply.’

And now we’re only going to compare those 3 tables.

Sweet.

And then we’ll get our results, as you normally would using the Database Diff item on the Tools menu.

I’m missing some important stuff it appears.

More on the Cart

The Cart can do a LOT.

Exporting Multiple Tables to a Single Excel file using the Cart

Use the Cart to Build Deployment Scripts

Introducing the ‘Shopping’ Cart

Batch Load Your Cloud via the Cart and our command line interface

More on Database Diff

Compare Objects from Multiple Schemas

Database Diff Enhancements

PS What about PL/SQL?

Yeah, you can drop that into a CART and do a DB DIFF to compare your PLSQL objects as well.

It’s just a text-compare…

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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:

  1. Those that code willy-nilly: they build out each variable, procedure, type, function as it pops into their mind
  2. 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.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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, ...
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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 (+) ...
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview