I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
oracle rest data services modules ORDS

Let’s say you have some files, stored as BLOBs, in your database, and you want to make them available via REST. So of course you install Oracle REST Data Services, and now you have two options: REST Enable the table or Deploy a custom RESTful service With the first option, I get an ‘automatic’ REST endpoint for my resource, which in this case is my table that has the BLOB, but I don’t want or…

SQL Developer

Remember this fancy do-hickey? It’s the Instance Viewer. We introduced it as a new feature in version 4.1. For version 4.2, we added this – the Top SQL panel. We ask the database every 10 seconds what the most expensive query by CPU is. Maybe that’s a bit too aggressive for you? What if you only wanted to ask every…10 minutes? You can do this. You’ll want the Instance Viewer to be open and running,…

SQL Developer

Dealing with a complex data type? Say, XML? Or, a nested table? If you want to see a ‘flat’ view of the data for that bit or a row when browsing a data set that contains that TYPE of data, you’ll want to check this preference. Using the code sample from OraFaq – thanks folks! – here’s what I mean. But, if we double-click on the cell… And after that click… If we ran this…

SQL Developer

Someone on the Forums (yes, we read and respond!) noticed they couldn’t add Bytes or Time to their plan displays in Oracle SQL Developer. So we just made all of the columns available now, even if a few them might not make sense, i.e. TEMP_SPACE, OTHER. Preferences – Database – Autotrace/Explain Plan New things highlighted/boxed… So let’s look at a plan from V$SQL_PLAN…a la hitting this button – For AutoTraces you can also ask to…

SQL Developer

Happy 2017! Here are your 10 favorite posts from last year. 1. Exporting Multiple Tables to Multiple Excel Spreadsheets Want 6 tables’ worth of data to go to single Excel file? Or one table per file? Here’s how to do that. 2. Oracle SQL Tuning Advisor and SQL Developer Own the Tuning Pack? Have SQL Developer? You should be using that then. BONUS POST: Viewing your automatic SQL Tuning Advisor Job Reports. 3. Can Oracle…

SQL Developer

Tons of bugs fixes based on your feedback, especially with the formatter. A few more changes with the formatter: we added more preferences for more flexibility we let you submit code to ‘shape’ the formatting preferences automatically we exposed the brains of the formatter so you can do pretty much whatever you want An example of the formatter ‘by example’ I’ll talk about the formatting ‘gut’ being exposed in a later post. But we did…

oracle document store json soda sqlcl SQL Developer

JSON – it’s the new whiz bang. JavaScript has taken off, and you don’t need to take my word for it. And with JavaScript comes JSON. There are so many libraries on GitHub that are about turning data into really slick web and mobile applications. We have our own set of libraries available – have you heard of Oracle JET? So JSON is here for awhile. What can you do with it? Well, you know…

SQL Developer

When I make jokes about copying and pasting code from StackOverflow or Github, I’m not really joking. But in this case, it’s OK. Because, I’m copying and pasting code from OUR GitHub project, AND my boss wrote the code. A question came in, and it’s come in a few times, but here’s the most recent variant: @Rumtis no way – you’ll need to write your own custom formatter with the SCRIPT (js) command— SQLcl (@oraclesqlcl)…

SQL Developer

I made some small, but important changes to my SQL Developer Tips & Tricks slide deck. changed up the order – the first two tricks ARE THE MOST IMPORTANT now optimized for SlideShare – hopefully easier to consume in case I’m not there to narrate/live demo added a few teasers for SQLcl I really, really need about 90 minutes to do this session ‘proper’ in the real world. But, it will only take you a…

SQL Developer

I got a question from our internal mailing list… I would like to know how I can view historical SQL tuning recommendations in SQL Developer 4. I don’t want to run the sql worksheet manually but view the automatic recommendations as the query has been running already for several days now. I’m guessing their query hasn’t been running for several days, but has been executing multiple times over several days, so if the Automatic SQL…