ThatJeffSmith

Category: Database Stuff

Importing Your Data Dictionary to a new Oracle SQL Developer Data Modeler Design

I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer. So let’s do that now. Warning: Lots of pictures coming up. Want to import from SQL […]

Similar Posts by Subject Areas: , , ,

Data Modeling via Excel?

In SQL Developer if you use the Import Data feature from the main tree node, it will create a new table based on a delimited text or Excel file. We’ll look at the data and create some columns for you. In version 4.1, we’ll recognize numbers as numbers, dates as dates, and try to get […]

Similar Posts by Subject Areas: , , ,

How Do I Switch Tools and Start Using SQL Developer?

So you have decided to give Oracle SQL Developer a try. You’ve been working with Oracle for 15+ years, and you’re a bit set in your ways. But not THAT set in your ways. Want some advice for getting started in SQL Developer? Here goes… Go cold turkey. Put down your other tool(s). Pick up […]

Similar Posts by Subject Areas: ,

Oracle SQL Developer and Docking Panels

While at Open World, I noticed Oracle ACE Director Heli‘s desktop was setup very nicely for working with the Data Modeler. I asked if I could share it with you all, and she graciously agreed. So how do you get the panels to dock where you want them to in SQL Developer? By the way, […]

Similar Posts by Subject Areas: , , ,

SQL Developer Reports: Reference Lines in Charts

The ubiquitous HR.EMPLOYEES table – how many different ways can we look at this data? How much money people make, by department? By reading the column comments, we know that HR.EMPLOYEES.SALARY is “Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)” So let’s chart that. This charts the data we […]

Similar Posts by Subject Areas: , , ,

30 Posts in 30 Days: The Reckoning

For the month of September 2014, I published a SQL Developer tip each day. September has 30 days, so that equated to 30 posts. Now normally, I post anywhere from 1-3 posts a week. Going from that to 7 days a week meant a few things: posts were going to be shorter – especially on […]

Similar Posts by Subject Areas: , ,

Day 27: Oracle Open World

The crazy starts tomorrow. Most of you won’t be here. But. You can get the software being used to demo everything this week. The Developer Day VirtualBox image has been updated as of yesterday. The biggest update is that it has 12.1.0.2 of the database on it. All that In-Memory awesomeness No pics today, I’m […]

30 SQL Developer Posts in 30 Days, Day 26: Keyboarding from the Editor to the Results and Back

Using the mouse sucks. You love the mouse. Leaving the keyboard gives your fingers a wonderful vacation. If you fall in the second camp, this post isn’t for you. But, if you want to be able to get from your query down to your results or explain plans without having to touch your mouse, this […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Posts in 30 Days, Day 25: Importing Partitioned Tables to a Data Model

We get lots of questions around how to model specific partitioning schemes in Oracle SQL Developer Data Modeler, and we do support all of the different ways to part and subpart your data – but today I want to show you: Where to see the partitions in the model How to bring in everything BUT […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 24: Hiding Schemas That Don’t Own Anything

Many applications will create user accounts in the database that do not own anything. They have privs to query the main application schema, but will never be used to create tables, views, etc. When you’re browsing the database via the Tree in SQL Developer, you probably won’t want to see these ‘fake’ users. Just Apply […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,