The old formatter, the code that’s used to format your code from v1 to version 4.1 was based on some pattern matching code and expressions. It was very limited, and didn’t like a lot of syntax and coding styles common in Oracle code. It also wasn’t very flexible. So we built a new engine. One […]
Similar Posts by Subject Areas: 4.2, code, formatter, sqldev
Someone said we should make the view source searchable, and that we should show any errors on a view. Actually, it might have been a few dozen of you. A reader reminded me that we actually implemented this in v4.2. Code Outline I’ll go into more depth here next week when I’m back from Open […]
Similar Posts by Subject Areas: 4.2, editor, outline, sqldev, View
In both v4.1.5 and v4.2, you can now select objects from your database tree, and drag them to another connection to have them copied. The source can be: a MySQL, DB2, SQL Server, Sybase, Terradata, or other 3rd party supported RDBMS an Oracle Database The destination can be: an on-premise Oracle Databaes an Oracle Database […]
Oracle SQL Developer Command Line (SQLcl) is now officially available. (Download) Thanks to the many of you who provided feedback and helped us make this ready. We plan on very regular updates, every 60-90 days, so the fun hasn’t stopped. Oracle SQL Developer v4.1.5 is now officially available. You can now drag and drop objects […]
As much as I like the Export Comments, or hints… SELECT /*insert*/ * FROM hr.employees or the less intrusive SET SQLFORMAT insert… sometimes you just NEED to use the Export feature tied to a grid. Did you know you can pre-select the defaults? For example, if 9x out of 10, you send the output directly […]
Similar Posts by Subject Areas: export, preferences, sqldev
Not to start a religious war, but white space in your code can cause havoc when you’re doing code compares and versioning. Some folks like tabs, others prefer to control how their code looks regardless of the editor’s tab display options. From what I can tell, SQL Developer’s code editors won’t even let you insert […]
Similar Posts by Subject Areas: code, formatter, sqldev, tab, whitespace
It’s already almost that time of year again. Which means I need to let you know what you can expect from our team at the world’s largest Oracle event – Oracle Open World. Sessions start on Sunday, September the 18th – but the fun with our team starts on Saturday morning. Kris Rice and I […]
I say designing, because I’m going to be talking about how to do this in SQL Developer Data Modeler. And I say Part Two, because in a previous post I showed how to draw a foreign key in your relational design. This post discusses how to control the generation of the foreign key column: to […]
Similar Posts by Subject Areas: data modeling, foreign keys, sqldev
The PL/SQL team is always reminding me to talk about PL/Scope. And I got to the point where I needed to remind myself, so I added this slide in all of my PL/SQL themed talks. Yet, I have apparently forgotten to blog about it. Oops. [Docs] PL/Scope is a compiler-driven tool that collects data about […]
Similar Posts by Subject Areas: identifiers, PL/SQL, plscope, search, sqldev
A friend of mine asked how he could generate CSV for 40 Oracle tables in Oracle SQL Developer. He could of course use Tools > Database Export to accomplish this. But, it was always the same 40 tables. And using the object picker in the wizard can get tedious, especially if it’s the same 40 […]
Similar Posts by Subject Areas: cart, cli, csv, export, sqldev
We spend a lot of time here talking about tips, tricks, and cool things that you might have missed. These posts generally all assume you’ve been around the Oracle Database block. But many of the folks that ultimately end up here, have NEVER touched an Oracle Database before. This post is for you. You have […]
Oracle SQL*Plus has been around since 1985. It does what it does, and it does it well. SQL Developer has been around since 2006. It’s become the de facto IDE and GUI for the Database. There was an opportunity to build something new that could take the command line interface and enhance it to meet […]
Today’s post is courtesy of this question from a reader: Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted? The answer is ‘Yes!’ I’m going to use HR.EMPLOYEES to give me my data. I start with… SELECT Hire_date, Salary FROM Hr.Employees ORDER BY Salary […]
You may want to audit or ‘journal’ changes to your data. As you update a record, add a record, or delete a record – log that change in a different table. When doing your designs in the Data Modeler, you can ask at the time of DDL generation to have the journaling table and trigger […]
Similar Posts by Subject Areas: data modeling, journal table, sqldev
Someone on the innerwebs asked how to show the data inside their user defined TYPE’d column in a table when querying it with SQL Developer. Here’s their code: CREATE OR REPLACE TYPE ANSCHRIFT_T AS OBJECT (STRASSE CHAR(12), HAUSNR CHAR(3)); CREATE TABLE VERTRETER(V_NR NUMBER(4) PRIMARY KEY, ANSCHRIFT ANSCHRIFT_T); INSERT INTO VERTRETER VALUES (1, ANSCHRIFT_T(’TESTWEG’,’14’)); […]
Twitter
RSS
GooglePlus
Facebook