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…
I love performing my tips & tricks session. No two talks are alike. I frequently update the slides and content to account for new things I’ve learned and new features we’ve added. But. I’ve been delivering this talk going on 4 years now. Should I let my talk at Open World 2015 be my last hurrah of this topic for awhile? Maybe do more talks on Oracle Cloud, REST, data modeling, reporting, tuning, database administration,…
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…
You do your job. You take the requests from the customers, and give them to the engineers. Wait, that’s me. Your job is probably something more like, you write SQL and PL/SQL, you build databases, you create reports, forms, and applications, you keep all of this running, you make it work, and you make it ‘fast enough.’ For much of your work, you live in SQL Developer. You are probably doing these types of things:…
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.…
We updated the Early Adopter offering of SQLcl today. Go get it. But first, I’m assuming you’ve heard of SQLcl? If not – Read the slidedeck, watch the movie. We’ve put in a ton of enhancements and even more bug fixes. And Kris showed off a new feature today that mimic’s our SQL Developer grid preference for displaying NULL ‘values’… Make null values stand out #sqlcl pic.twitter.com/kBubvKHrUD— krisrice (@krisrice) June 16, 2015 But what I…
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…
We have been running an experiment for the past few months: if we host a weekly online webinar, will anyone show up? We – the Database Developer Tools team, mostly – want to try different things, find different ways to reach new developers and make Oracle Database as approachable as possible. For example, this week Product Manager Melli Annamalai – she is a BIG DATA expert, so don’t miss this one!!! – will be doing…
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…
For some reason I decided to re-join a discussion in the SQL community from way back in 2012. THIS => "tbl_ is a tell for bad database design" via @datachick http://t.co/hq2BH73xic sorry @SQLRockstar— Jeff Smith (@thatjeffsmith) May 28, 2015 Karen started it, Thomas ran with it, and I decided I had to throw my 2 cents into it as well. The short version: it’s hard to know what you’re looking at in database code (read:…
