Below you'll find a list of all posts that have been tagged as “video”
I was inspired by Joel’s post on this subject for APEX so much, that I thought I’d copy his idea. So you’re reading this post on my blog, so you found me – maybe probably via Google. Or you walked into my mom at the grocery store. Either way, so glad you got here. But did you know, there are …
I’ll show you 3 cool tips and tricks for working with PL/SQL in SQL Developer…in under 7 minutes! In-code navigation – click into where your objects are declared Test Query – see if your SQL is gonna work BEFORE you compile it Using the Code Outline For those that can’t do video, basically you can Ctrl-Mouse-Hover Navigate ANYWHERE Not just …
15 minutes overview of how to use these features in Oracle SQL Developer: Get an Explain Plan Customize the display of the plan Get a cached plan Use DBMS_XPLAN Compare Plans Use Real Time SQL Monitoring Use AutoTrace. And if you want an awesome video, MUCH more in depth about how to read a plan, then I suggest this from …
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 …
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, …
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 …
We are now live in the Oracle Cloud with Oracle SQL Developer Web. Wait, what’s SQL Developer Web? It’s a browser based version of Oracle SQL Developer powered by Oracle REST Data Services. If you are a Database Cloud Service customer in the Oracle Cloud, it’s rolling out now to those subscribers. If you’d like to know more and see …
In this 10 minute video I’ll show you: how to open a panel how to move a panel how to reset your desktop if something gets ‘borked’ how to create new desktop tab groups (for docking things) AND how to ‘float’ your doc or panel to a secondary monitor Welcome 2018! Please be sure to subscribe to my YouTube channel …
I’ve got short videos for you, 2-10 minutes. I’ve got 20 minute videos. And I’ve got monster, hour long videos. 24 in total, covering everything from how to use the PL/SQL debugger, to building REST Services, to just writing better SELECT * queries. Send me your requests, always happy to build more. I just wish I had a voice made …
Developers hate using a mouse. Sticking with the keyboard reminds everyone we bled all over our keyboards 20 years ago in VT100 terminals. So we built a modern command line interface for Oracle Database and released it last year, in 2016. And knowing you already know and love the keyboard, we made sure you could do what you needed to …