ThatJeffSmith

Category: Database Stuff

Can Oracle SQL Developer do that?

Here’s a quick run-down of FAQ’s I get when doing presentations or demos. Can SQL Developer… Extend a tablespace? Yes. You can edit an existing data file or add a new one. We’ll also show you the SQL that’s going to be used so you can copy it to run in SQL*Plus or wherever. And […]

Similar Posts by Subject Areas: ,

Why DESC When You Can INFO in Oracle SQLcl?

INFORMATION is a new command available in SQLcl, a command-line interface to Oracle Database. [email protected] >help information INFORMATION ——–   This command IS LIKE DESCRIBE but WITH more details about the objects requested.   INFO[RMATION] {[schema.]object[@connect_identifier]} INFO+ will SHOW COLUMN statistics   [email protected] > It’s available for tables and views, of course. Here’s a table. […]

Similar Posts by Subject Areas: , ,

Viewing BLOBs in SQL Developer as Text

I have talked about how to preview BLOBs (Binary Large Objects) as pictures… But someone on Stackoverflow asked how to read a BLOB value if it had text. So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then loaded that to a table as a BLOB. Then I […]

Similar Posts by Subject Areas: , , ,

A Place to Learn Oracle, No Setup Required

I answered this question on Quora yesterday: What are the best resources for learning Oracle Database? The biggest learning curve to learning Oracle Database, SQL, PL/SQL, and all the other cool technologies that come with our database, is figuring out how to download, install, and create a database FIRST. And then of course you’ll have […]

Similar Posts by Subject Areas: ,

2 Reports You Might Enjoy in Oracle SQL Developer

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer. Today I’m going to share 2 reports that I frequently forget about, that you may enjoy. Finding Unindexed Foreign Keys We all know this should not happen. We all know it eventually happens. Here’s a report to […]

Similar Posts by Subject Areas: , , , , ,

Case Closed: lower, InitCAP, UPPER, And Stuff

Best practice for code readability dictates that your keywords should always be in: insert your preferred style here __________. Here’s a Twitter poll I’m running if you want to personally weigh in: Do you agree? Best coding practices dictate uppercase identifiers? https://t.co/WhOZvL2Bmv — Jeff Smith ☜ (@thatjeffsmith) March 16, 2016 So even if we can’t […]

Similar Posts by Subject Areas: , , ,

SQLDev Trick: Alphabetized Column List in the Single Record Viewer

This trick’s title might actually be longer than the content – so guaranteed QUICK read! Question from a reader: is there a way to alphabetize the columns in the Single Record View? Quick Answer: No… Column order is usually something the application architect or data modeler deemed important, so we always show the column in […]

Similar Posts by Subject Areas: , , ,

Make SQL Developer Run Faster

Forgive the inelegant post title – but it gets to the point, and I reckon it might be closer to what folks will be Googling. I get questions from time to time around getting SQL Developer to load or respond quicker. Here’s the advice/tips I generally lead with: Look and Feel You can tell SQL […]

Similar Posts by Subject Areas: , ,

3 Oracle SQL Developer Features Every DBA Should Know About

I just came from a DBA-dominated conference – Hotsos Symposium in Dallas, if you must know – and I came away with the impression that many a DBA out there is missing out on some key features and productivity-hacks in our dear ole IDE. I could give you 10 things, but I know DBAs are […]

Similar Posts by Subject Areas:

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

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,