Someone asked the other day, ‘how can I make tables show up in blue?’ In the preferences, find the ‘PLSQL Identifier’ entry in the PL/SQL Syntax Colors entry, and set it to whatever color you’d like. Another example… Grammar Squiggles, They’re Hard to See Sometimes This time, look for the ‘Disconnected Join Graph’ entry. One […]
30 SQL Developer Tips in 30 Days, Day 2: NLS Parameters
This might be the most important set of preferences in Oracle SQL Developer. The settings on this page directly impact how your queries run and the results they return. One of the most curious and fun to debug questions I get from users is something along the lines of… Why does my query return X […]
30 SQL Developer Tips in 30 Days, Day 1: Help with WHERE Clauses
For the month of September I’m challenging myself to perform two different feats of strength: Do 5,000 push-ups in the month of September Post a SQL Developer Tip or Trick every day for the next 30 days I’ve noticed my posts are starting to go out once or twice a week, and I like to […]
Oracle SQL Developer: Code on Demand
I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… …but I’m lazy. So this: The Setup Open your preferences and go to the SQL […]
Non-English Character Display in Oracle SQL Developer
I get a variation on this question at least once a week, if not more frequently. I’m from Israel, and the language on the databases is Hebrew. When I use the old and deprecated SQL*Plus (windows rich client) I can see the hebrew clearly, when I use the latest SQL Developer, I get gibberish. This […]
Showing Foreign Key Names in your Data Modeler Diagrams
Very quick and short post today. The question: In version 4 of Oracle SQL Developer Data Modeler, how do I get the names of foreign keys to appear on the relational model diagram? First of all, right click in the diagram space: With this on, your diagram will now look like this:
SQL Developer Quick Tip: Running Scripts off the Web
Did you know you can run SQL*Plus type scripts directly from the web? Now, I’m going to assume the following: You know, trust, and have tested these scripts You don’t assume that everything on the Internet is true That Tim doesn’t think I’m trying to suck up to him, much So, in a SQL Worksheet, […]
Oracle SQL Developer Code Insight Syntax Examples
There really are times your tool is smarter than you are. Thank you #SQLDev Code Insight for listing syntax examples. @thatjeffsmith — Amy Caldwell (@amyccaldwell) August 7, 2014 In fairness to Amy, I don’t think SQL Developer is ‘smarter.’ I think it just has faster access to the Oracle Docs than she does. And SQL […]
SQL Developer at Oracle Open World 2014
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 […]
Oracle SQL Developer Around the World
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 […]
Copy & Paste Imports from Excel to Oracle using SQL Developer
Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table. AHEM. In the video you see me selecting the cells in the Oracle table editor before pasting the new […]
Viewing Complex Types in Oracle SQL Developer Data Modeler
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 […]
3 More Oracle SQL Developer Bloggers
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 […]
Clearing the Script Output Buffer in Oracle SQL Developer
Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block? Quick Answer: CLEAR SCREEN [Oracle Docs] SQL Developer supports many, and soon to be ALL, SQL*Plus commands. CLEAR is one of them. So just add this to the top of your script. When you […]
How to Generate Schema DDL Scripts with One File Per Table using SQL Developer
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. […]
Twitter
RSS
GooglePlus
Facebook