Working on some cool demos around JSON, ORDS, Oracle Database, JavaScript apps, etc. and I needed to load up a BUNCH of data to play with. Note the ‘other_tags’ column LOOKS like JavaScript Object Notation (JSON). There are JSON standards – should the key name and value strings be double or single quoted, etc. To ID text as JSON in Oracle it needs to pass our test. Also, you need Oracle 12c, specifically 12.1.0.2 (and…
How often do you need to build a new table to test something out? How often have you typed CREATE TABLE AS SELECT… If the answer to both of those question is ‘quite a bit Jeff!,’ then continue reading. In SQLcl, we have built a new command simply called ‘CTAS.’ So let’s try it out. What tables do I have to work with? I’m lazy, so instead of typing ‘select table_name from user_tables’ I just…
This is one of the features I showcased in a webcast yesterday – looking for a particular column definition in your relational model? We make that easy in SQL Developer. And, after you find all of these columns, you can quickly change them, all in one fell swoop. Ctrl+F in a model to open the search. Toggle to ‘Advanced.’ Set your search area and criteria. Hit the ‘Search’ button. Review the results, save as a…
This post will show how to connect to your Database as a Service environment running in our Oracle Cloud using Oracle SQL Developer. The screenshots below and demonstration steps are written with version 4.1.1 of SQL Developer. We (Oracle) basically have 2 types of Database services you can run in our cloud: Schema – known as Database Schema Service Database – known as Database as a Service (DBaaS) I’ll be talking about the DBaaS offering…
I’m at the beach! But if you desire fresh SQL Developer-themed content, then you are still in great shape. Check out these blogs: The Data Warrior AKA Oracle ACE Director Kent Graziano Heli from Finland AKA Oracle ACE Director and published author Heli Helskyaho Kris Rice Colm Divilly Barry McGillin Not Enough? I have a YouTube Channel with SQL Developer videos, because reading is boring. Moving pictures are so 1894. I have a SlideShare channel…
The team just got back from another Oracle User Group Conference, or I should say THE conference. I know most of you don’t get to go to conferences. Or have nice computers. Or use foreign keys. Or have nice things. BUT. One thing you do get to have today, is the same popular Oracle SQL Developer features demonstrated to you, right now. These are things that people ask me to demonstrate to them, the most.…
Most folks know they can filter their list of Tables. But did you know you can set a global filter across your entire connection? It’s pretty basic, but also pretty powerful: So how would this be useful? Maybe for your project or program module, you have all of the objects starting with the same prefix. You can now filter your database objects to just that module or application feature. These are database side filters -…
I had a fun conversation with @tmuth today: I attempted to distill my entire tips & tricks ‘sermon’ down to a single suggestion. For productivity, I suggest every user get comfortable with Document Tab Groups. So if you want to work on a stored procedure while you browse a table, right click on your document tab, and add a new document tab group. This allows you to SEE more than one editor at once. You…
Updated September 2020 This is going to be a FAQ. I get these questions all the time, and I need a place to send people when I don’t have time to live-demo. If your question isn’t below, add yours as a comment. If you want to know what the debugger is or why they might try it over DBMS_OUTPUT, read this. Or skip all this and just go through the slides and YouTube video Debugging…
There’s quite a few things you can accomplish by manipulating and tweaking our data grids in SQL Developer without having to write a single shred of SQL. I’m not going to flood you with 35 blog posts on the subject. But I’ll share a few that will give you an idea, and if you’re interested in the others, use the ‘Search’ mechanism up top of this page to find what you want. A few Data…
