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

I’m lazy. I don’t like having to look up the directory name/structure when creating a new datafile. I don’t even like having to copy and paste it. So I avoid all of that, by using the CREATE LIKE dialog. View > DBA Add a connection. Open. Storage. Datafiles. Find one in the tablespace you want to add space for. Right-click. Now just fill in the details, or change things up as needed. Can’t Figure Out…

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…

reset password oracle sql developer SQL Developer

Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database. Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available. A post I did up explaining this is one of the most read articles on this site – you can imagine how many users out there have expired passwords and…

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…

Database Stuff

Oracle Application Express on APEX.ORACLE.COM was upgraded to v5.1 last week. One of the new things coming in v5.1 is a new packaged app called ‘Quick SQL.’ VP of Development Tools Mike Hichwa demonstrated it at UKOUG Tech 16 this month, and the audience seemed to eat it up. Basically, it allows you to use a shorthand of sorts to describe a table or tables, and it will generate the DDL for you. Heck, it…

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

Are you smarter than the optimizer? Are you hiding critical information from it? Perhaps your stats are missing, stale, or a bit misleading? I don’t want to get into whether hints are good or bad – they can only be used to accomplish good or bad things. They are often absused – so please don’t take this post as carte blanche to go crazy with hints. But. What if you could easily tell the Optimizer…

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…

SQL Developer

Someone asked: @thatjeffsmith Great blog! Is there a way to display DB Doc in SQL Developer like in Java IDEs with Java doc while being in Code editor?— Sebastian Köll (@s_koell) December 1, 2016 And here’s the answer – Yes! First, let’s talk about PLDoc, and how it works in SQL Developer. All caught up? Great. Now let’s show you how to preview your fancy code doc before you go to generate the HTML. Put…