ThatJeffSmith

Tag: sqldev

Advice on Finding Your Way Around a New Oracle Database

Received this query from a customer this morning… For your information, I’m average in SQL. What I would really like to know is if you can give me some tips regarding the use of Oracle SQL Developer in relation to a completely new database. So, are there functions/tools in Oracle SQL Developer which can help […]

Similar Posts by Subject Areas: , , , ,

Formatting Columns in SQL Developer a la SQL*Plus

Does SQL developer support, col command that is used to format query results in sqlplus. like – col id heading app_id format a10 My answer was: ‘Yes.’ But I figured I should put up or shut-up a little bit, so here goes. You can read more about column formatting in SQL*Plus here (Docs). I used […]

Similar Posts by Subject Areas: , ,

Getting Your Plans via SQL_ID

@thatjeffsmith hi Jeff, is it possible to see execution plan just by passing sql_id somehow,i dont think so as it just show running sql plan — Mayank (@mayankeurope) February 15, 2016 So of course you can just run a query in the worksheet to get this. But, you need to know a few things. So […]

Similar Posts by Subject Areas: , , , ,

What the SQL? (History)

Oracle SQL Developer has 2 client-side logging mechanisms for capturing SQL that is executed: SQL History Statements SQL History This is the SQL that you have executed in a SQL Worksheet. It’s also any scripts you have executed in a SQL Worksheet. Ran something the other day and forgot to save it to your script? […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer, In a Nutshell

Idiom:in a nutshell In a few words; concisely: Just give me the facts in a nutshell. Ok, so I used more than a few words, but if I told you that SQL Developer was a GUI version of SQL*Plus – I’d be leaving out a WHOLE LOT of important stuff. If that’s all you’re using […]

Similar Posts by Subject Areas: ,

Modeling Virtual Columns

Virtual columns made their debut in Oracle Database 11g. They are a value that’s not stored with the row, rather they are computed as queried. [DOCS] So I could have a column of type DATE. And I could have a virtual column of type VARCHAR2 that is computed by running a function against the previously […]

Similar Posts by Subject Areas: , , ,

SELECT SPLAT…To Just the Cols You Want

Question: I like SELECT *, but I don’t really want ALL the columns. Is there a better way? Side Note: People are giving me crap on the ‘SPLAT’ – it’s perfectly acceptable! To me at least… There’s a few better ways, and with an IDE like SQL Developer, you should expect lots of help in […]

Similar Posts by Subject Areas: ,

Your Favorite Posts from 2015

These were the stories published this year that enjoyed the most readers. Sadly, an article I wrote many years ago on how to import data from Excel to Oracle, remains the #1 post overall. Stupid Excel. 10. SQL Developer version 4.1 Feature Recap So we released version 4.1 of SQL Developer this past May. This […]

Similar Posts by Subject Areas: , ,

SQLcl: Optimizing Your History Lists

Since SQLcl is a command line tool, it’s not super helpful to have a huge command history list. How do I mean? Well, in the SQL Developer GUI, we have a History panel. It allows for sorting, filtering, scrolling, etc. So you can go ‘crazy’ and set your History limit to 1000 if you want. […]

Similar Posts by Subject Areas: , ,

10 Years & Counting, Rock On

Doing the math, SQL Developer is officially 10 years old. Or should I say, 10 years young? I remember VERY clearly when this came out. It was seen as a very disruptive move by Oracle – a company for which I did not work at the time, so this is my personal recollection 🙂 It […]

Similar Posts by Subject Areas: ,

Your Definitive Guide to SQL History

I went to link to this post earlier today, and was shocked to discover I hadn’t actually written it yet. What’s the opposite of ‘bazinga!’ ? SQL Developer stores every query AND script you execute in a worksheet. A query being a single statement, and a script being one or more queries and/or anonymous blocks. […]

Similar Posts by Subject Areas: , , ,

5 SQLDev Features I’m Thankful For

I hope this post isn’t too cheesy. But it’s Turkey-week here in the USA, and the theme demands that homage be paid. So here are 5 features in Oracle SQL Developer that I use all the time, and am truly thankful for. They help me conserve energy, AND they make my job easier. I want […]

Similar Posts by Subject Areas: , ,

Click vs Type…Again.

This might sound preachy, but it’s mostly not intentional, mostly. You might really enjoy the flexibility of the PL/SQL APIs the database provides for things like Resource management, the Scheduler, Data Pump. You might even have memorized the PL/SQL function/proc names and arguments required to create a job, or change up a resource. But do […]

Similar Posts by Subject Areas: , , ,

Object Search in SQLcl?

I’m always looking for things. I love the ALT+G trick in SQL Developer. But what about the command-line? One of the really nice things about SQLcl is that if you can’t do what you want with the available commands, you can just build your own. That’s especially true now that we have JavaScript support. But […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,