ThatJeffSmith

Category: General

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: , ,

SQLcl Updated: Bug Fixes

There’s an update available for SQLcl on OTN, go get it now. We’re closing bugs left & right, and we’re super close to 100% SQL*Plus support now. As an example, we now support SET PAGESIZE 0…which comes in handy apparently if you want to spool a file w/o a leading blank line as described here.

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: , , , ,

Get Help, Just Hit TAB

You’re at the command-line, you need to add a data file to your tablespace. You get most of the way through it, and you forget what’s next, doh! In SQLcl, you can just hit the TAB key, and we’ll help you with the next keyword. So not only do we have tab-completion for object and […]

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: ,

Using Reports to Print CLOBs

A co-worker asked me for some advice on building a report to view some CLOBs. CLOBs are fun. They let you store an unlimited (basically) amount of text. They’re not as flexible as VARCHAR2s, but they do come in handy. Viewing them in a report can get interesting though. The question came down to seeing […]

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: , , ,

A Friend Could Use Your Help

My friend Chet is facing some pretty large bills. They go to pay for therapy for his special needs daughter, Kate. Chet is @oraclenerd. He’s done a lot to help the community, and to help community members in need. We’ve started a fund-raiser to help Chet make sure his kids get the care they need. […]

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: ,

Resolutions for 2016

Our Database Insider Newsletter folks asked me to share some resolutions I had for 2016. 2015 was a great year for me, personally and professionally. I’m also continuously reminded of the things I don’t do so well and need to get better at. So here goes… Find new ways to reach and help our users. […]

Similar Posts by Subject Areas: ,

More SET SQLFORMAT fun in SQLcl

DELIMITED text files are popular ways of passing data around. CSV anyone? The C stands for ‘Comma’ – regardless of what your smug European friends may have told you 😉 #TonguePlantedFIRMLYInCheek Anyways, in SQL Developer, when using the export dialog to get a DELIMITED export for your dataset, you can set the delimiter and the […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,