Category: Database Stuff

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 […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,