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.…
One of the new Database 12c features is the SQL Translation Framework. Developed primarily to help customer migrate their 3rd party applications and databases to the Oracle stack, it also offers application DBAs an opportunity to substitute poorly performing SQL with their own custom SQL – without changing the application itself! Do I have your attention now? Kerry Osborne wrote an excellent post on the topic using a closer-to-real-world example and shows the pl/sql package…
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…
You backup your databases, right? You backup you home computer – your media collection, tax documents, bank accounts, etc, right? You backup your handy-dandy SQL scripts, right? Ok, now that I’ve got your head nodding, I want to answer a question I get every so often: How can I manage my scripts in SQL Developer? This is an interesting question. First, it assumes that one SHOULD manage their scripts in their IDE. Now, what I…
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…
What is Oracle SQL Developer? Well, according to this document on OTN… What is SQL Developer? Date: May 2014 Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer’s main objective is to help the end user save time and maximize the return on investment in the Oracle Database…
So you just got your brand new machine at work. Party time, excellent*! Amazon.com Widgets And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer. But when you go to use it, none of your connections are there. Or maybe the connections are there, but the connection passwords ARE not. And really, who has the discipline to have 300 different passwords for all of the databases memorized and ready…
BLOBs are cool. Optimized such that you can store files basically in the database, with the power of SQL AND no performance hit. That sounds like a pretty good deal. I get asked questions a lot about accessing BLOBs once they’re in the database. And that’s led to quite a few posts here on the subject: Viewing BLOBs as pictures Viewing BLOBs in External Editors (PDFs, spreadsheets, etc.) Including BLOBs in your PDF reports But…
I said earlier today that version 4.0.2 of SQL Developer consisted on ONLY bug fixes. I should have said MOSTLY bug fixes. There was also one minor tweak, although it was a minor tweak to a major feature: Completion Insight. This is the feature that kicks in while you are typing – suggesting column or table names to help you complete your SQL statements in an editor. Watch this quick video to see it in…
As of late yesterday afternoon, we have two new updates for you: Oracle SQL Developer v4.0.2 – bug fixes only Oracle SQL Developer Data Modeler v4.0.2 – bug fixes and a few tweaks You can read the release notes to see exactly what’s changed. For SQL Developer, the major things are an update to fix some issues with our Data Miner extension, and 5 or so UI bugs in SQL Developer itself. Also, if you…