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 the order in which they’re defined in the DDL. BUT, when browsing really wide tables, it can be hard to…
I accidentally blogged this…twice. Here’s the other take. This happens more often than I care to admit, sorry. 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 Developer to…
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 me better understand a new database and it’s structure/tables/etc. I’m not looking for tips regarding creating a new database. I’m…
If you have the Tuning Pack licensed, a couple of things become available for you in SQL Developer: SQL Tuning Advisor Real Time SQL Monitoring If you DO NOT have this pack licensed, then you can disable these features in the SQL Developer UI via the preferences: Semi-Rant: consider giving your developers access to this feature in their development and UAT environments. SQL Developer, EM, or just grant them exec privs on the packages and…
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.
@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 why not make it easy on yourself and code it into SQL Developer as a report? So that’s what I’ve done…
I tried to reference this post, and couldn’t find it. So apparently I have to write it now. I want to write a query. I want a bunch of column names. I could do this: But I’m very particular. Or maybe my customer is very particular. She wants SALARY then LAST NAME then FIRST NAME then EMPLOYEE ID. And so because I’m a lazy typer, I’m going to give my fingers a break and pick…
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 column names, we also look up keywords from the syntax diagrams in the Oracle Docs. Confused? Here’s an animated GIF.…
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 a report like this – I suggested to my co-worker to use the SCRIPT type report instead. But then they…
We love getting enhancement requests from our users. A good deal of the development in SQL Developer is guided by what our users are asking for. It does pain me a bit though when someone asks for a feature what we already have. Example: We frequently have a requirement to export working data (especially for data modeling purposes) to spreadsheets. It would be helpful if SQL Developer export had an option to export all tables…