It’s a bit long at 17 minutes, but I go through the process of: creating a new table based on an Excel/CSV defining the columns checking the column names checking the column definintions is the column wide enough? defining DATEs running the export fixing errors saving the scenario so you can run it on demand Remember, if you prefer to …
Where Desktop and Web Collide – Sharing Data Modeler Diagrams
You might have heard we now have a new SQL Developer in the family: SQL Developer Web. If that’s news to you, here’s a quick video recap: Hopefully you noticed that one of the main features of SQL Developer Web (and SQL Developer Desktop!) is data modeling. We were thinking: wouldn’t it be nice if could pull up a diagram …
KScope18 Sunday Symposium Slides
This past week we were at KScope – the premier all things Oracle conference here in the United States. The Database team were very well represented, and we did 15 minute lighting talks. Maria has already shared her slides/talks here – they were AWESOME! Here are mine. Let’s Go Shopping It’s all about the Cart. Oracle SQL Developer: The Cart …
Easier Preferences…Digging
We have a LOT of application preferences. And users have a funny habit of asking us to add MORE to every release. So, it’s great that we make it very easy to customize their SQL Developer experience via a few clicks and toggles. But, it’s kind of hard to find the RIGHT switch when you want to go change something. …
New Oracle VirtualBox Appliance Available
You can download it here. With this VirtualBox Appliance, you can spin up a virtual machine that already has Oracle Database, Application Express, REST Data Services, SQL Developer, SQLcl, and more…all running for you, automatically. The APEX team has also given you a TON of new APEX 18.1 focused labs. Including one for using REST Enabled SQL from ORDS. How …
SQL Developer Reporting: Video Demo & Slides
As a feature: Been there forever On the desktop by default 80% of you aren’t using it I think it’s a feature that can really turbo charge your experience with the database and SQL Developer – so I did a 10 minute talk on the subject. So if you’re curious about what you might be missing, here you go! And …
ODTUG KScope 18 Sunday Symposium Preview
This year the KScope conference is in sunny Orlando, Florida. Do you live in the area? Do you work with Oracle technology? Then I’d like to invite you to come hang out with us for a very special week. On Sunday, we have 6 dedicated hours to talk about all things Oracle Database, in a series of lightning talks. In …
Demonstrating Oracle SQL Developer Web: CREATE & ALTER TABLE
In two previous posts, I have: Introduced Oracle SQL Developer Web and did a quick demo of the Worksheet Demonstrated the data modeler diagramming feature. Today, I want to show you our CREATE and EDIT TABLE dialogs. While I aim for 10 minute videos, I had to go into overtime, and came out at 13 minutes. But as a bonus, …
SQL Developer Tips & Tricks: The GIF
Not able to make my Tips & Tricks talk at the Great Lakes Oracle User Group conference this week? Don’t have the 50 minutes to watch my recorded YouTube version? Can you spare 90 seconds? You don’t even need to turn the sound on. Just watch this GIF. To recap: ALT+G to do a search Use Doc Tab Groups to …
Demonstrating Oracle SQL Developer Web: the Data Modeler
In this 10 minute video, you get: super quick recap of the Worksheet building a new diagram moving stuff around, changing the colors generating DDL generating a data dictionary report saving and searching diagrams This was my 50th post on YouTube. If you like what you see, be sure to subscribe there so you don’t miss any updates. Your subscriptions …