Skip to main content

Posts

Showing posts from 2019

Sample Data Sets in APEX

Sample data sets are something that I use very often. Either I'm trying out some new features, working on a presentation, preparing a workshop,... For me still the favorite data set is the King with a salary of 5000...or in other words the SCOTT schema with a famous DEPT and EMP tables. If you have never heard about the SCOTT schema, then it must be that you are really really young :). In that case you can read more about SCOTT schema  here . And if you don't know who Scott is, then check this link . If we want to have this sample data set in our custom schema then we need a script that will create the tables along with the data. One of the places where we can get the script is for an example on Github . But if we are working with APEX all we need are a few clicks and we are good to go. Once logged into APEX we have to select in the drop down menu :  Workshop > Utilities > Sample DataSets Once this page, all we have to do is click on "Install" n

Page Specific Utilities

First things first. Yes, it' has been to long since I wrote my last blog post. But you know what, it's not like I didn't had time or something like that...it was just that I lost my login credentials for blogger.com... Today I walked to the office and suddenly I remembered what my credentials are, and I also got an idea for a new blog post. Maybe it was due to the fact that it was a really nice walk...who knows :) I'm working with APEX for many years now and here and there I "discover" things that are there, I guess for ages, but somehow I have overlooked them. My last presentation that I did was "It's good to know your APEX backyard" for the APEX Alpe Adria conference . In this presentation I talked about that APEX is not only Page Designer, where we spend most of our time when working with APEX. But there is so much more then Page Designer. As part of the presentation I also covered Application Utilities and on the page with Page Utilit