I should have known this, but apparently we offer you up a list of your variables when working in the PL/SQL code editor. It even identifies my string and number variables as such. 42 words, so this is definitely a QUICK TIP.
Support for SQL*Plus functionality in SQL Developer has gotten better from release to release. In version 4.1 we took a giant leap forward, adding support for many SQL*Plus commands, and coming much closer to emulating script execution behavior. One example, we added support for BREAK and COMPUTE commands. Another change was adopting several of the SQL*Plus defaults, including pagesize. It’s not just the number of rows on a query, you also count blank lines, the…
You have some data. You want to email it to someone. You don’t want them to have to open an attachment. You want it to be in an HTML-Tabl’ish delivery device. In SQL Developer, write your query. Export to HTML > File. Open Outlook. Start your message. Attach File Point to your HTML File DON’T CLICK ON THE INSERT BUTTON On the INSERT button, there’s a drop-down widget. Click that instead. And then choose, ‘Insert…
We’ve been working on version 4.1 since last Fall, and I’ve been blogging about the new stuff all the while. In case you missed it, we officailly released version 4.1 yesterday 🙂 Here’s a quick index of all of those version 4.1 posts you may have missed: SET SQLFORMAT command and a new formatter, JSON a new Search and Replace interface Code Insight, more tweaks & improvements Easier Excel and CSV Imports Multi-Cursor (text, styping…
In a previous episode, I showed how quickly you can REST enable your Oracle Database tables and views. And I took a second or 3 to show how to create a module in SQL Developer’s REST Development panel, which allows you to have a RESTful endpoint served by a SQL statement which will bring your data back as JSON. Today I want to take another 30 seconds to show how to add a :BIND to…
We have a script execution directory setting in SQL Developer…but what about our new SQLcl command line utility? That was a question posed to me this morning. My answer was..well, let me show you my answer. 6374425266725a90635e10_000002 Now you can see why: My prompt is what it is My output is formatted nicely My script is able to be found In Case This is All New to You… SQLcl is a new take on SQL*Plus…
View – DBA – Security – Auditing A user asked how to use SQL Developer to audit user XYZ. And to be honest, it’s not really set up to work that way. You define operations or objects you want audited. Any user that does XYZ to object ABC will get logged. There’s an exception to this – you can setup SYSDBA users to be audited. This will grab the SYSDBA-level type operations that happen. Check…
Hopefully you’ve heard about the new SQL*Plus we’re building. And hopefully you’ve heard about the new REPEAT command we put into it yesterday. Here’s a quick example of how to build a little ‘monitor’ in just 2 commands, a total of 5 lines of code. The SQL 6374425266725a90635e10_000003 So run that, make sure you like the formatting, and the data of course 🙂 Then to turn that into a refreshing report, run this: SQL>repeat 100…
I don’t like deleting blog posts just because they’re old, or no longer true, but this one came before we made this SO MUCH SIMPLER. Please read this post instead. TL/DR? You can now just say SET DDL STORAGE OFF if you want to set the metadata transform bits 🙂 We’re getting much closer to having Oracle SQL Developer version 4.1 ready for release – which includes SQLcl, our new command-line interface for Oracle Database.…
Question: How can I make SQL Developer display the number of rows returned by a query? Answer: Execute the query, and fetch all the rows. But I’m not seeing it! and fetch all the rows. This part is important. Execution using ctrl+enter executes statement, and returns the FIRST ‘fetch’, by default of 50 records. First Fetch Last Fetch Warning: Rant ahead! …Until All Rows Are Read – there’s one or more proceses on the server…