Oracle Open World is just around the corner. Every year, tens of thousands of Oracle geeks gather in San Francisco for a week for learning, networking, and more than a little bit of fun and socializing. If you’re going to be there, here’s what you need to know about your favorite development tools team 🙂 Fun Stuff 3rd Annual SQLDev Golden Gate Fun Run 5k On Sunday before all the craziness starts, a few of…
Oracle SQL Developer is being used around the world. I see evidence of this in Indonesian tweets, OTN forum questions written in Spanish, talking to people at the larger tech conferences, and looking at our website Google Analytics. For just this site, here’s where people have visited from in 2014: If I look at the Browser Language configuration for site visitors, it’s 72% English, with the next top language being French at a little more…
Instead of having a column of type VARCHAR2 for a ‘Country,’ you might want to create an COUNTRIES type. Said COUNTRY would have an ID, NAME, and LOCATION. To make things even more fun, LOCATION would also be a custom type of LOCATIONS, having even more attributes/columns. To model these from scratch, you would build them in your design as part of the Data Types Model. You could then take advantage of them in your…
I’m on vacation this week – so in order to keep you folks entertained, I thought I would spotlight a few of our developers who also blog. Kris Rice Kris is one of the two original developers of SQL Developer. He’s also my boss, but don’t blame him for me. Lately, he’s been into all things cloud – especially taking our Oracle REST Data Services to the next level. But, he’s also into time saving…
I like to experiment and play with new shiny objects. LinkedIn recently added a blogging platform to their site. I’ve decided to publish a little thing on how to do a better job on writing abstracts for conferences. A few disclaimers: I’m no expert, but I write and review a TON of these Many people tell me they want to submit a talk, but don’t have the experience to do it up ‘right’ I mentioned…
A VERY specific request this morning: I want to generate scripts for all the tables available in schema. I want to generate separate scripts for each table available in schema and each script must contains it’s dependent objects like indexes for that table or if triggers are available the this must include in the script. I am using SQL developer 4.0.12 version. I tried with export option but separate scripts are generating for index,triggers,tables etc.…
I’m doing a talk on this very subject next week at ODTUG’s KScope14 conference, and I’ll put up the slides on Slideshare after the show, but I wanted to give a quick shout-out to the things you COULD Be using today to get the most out of your models and design experience. Search SubViews Reports Preferred Data Types Propagating Properties DDL Previews Drag ‘n’ Drop Tables from SQL Developer Tree Transformations Navigating Diagrams Design Collaboration…
Sometimes you need more memory. Here’s an example: you want to model a database that has 1500 tables in it. What would that even look like? If you zoom out far enough… Now, ‘large’ is a subjective term. But lets put it this way – if you’re dealing with more than several hundred tables or entities – that’s larger than most other designs. Oracle SQL Developer Data Modeler, and the modeling extension that runs inside…
There’s a nasty rumor going around that you can’t compare database objects and/or code in Oracle SQL Developer. So let’s put that to bed right now. First, here’s how to compare: PL/SQL to PL/SQL or a SQL statement to another SQL statement So now that that’s settled, why don’t we take a look at how to compare a single table, to another table – whether it’s in the same database or a different database. Database…
Tnsnames.ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases. This post is just a quick overview on how to get SQL Developer to ‘see’ this file and define a connection. There’s only a single prerequisite for having SQL Developer setup such that it can use TNSNAMES to connect: You have somewhere a tnsnames.ora file…
