It obviously takes a Joel Kallman Day to get me writing a blog post! And it does make sense since Joel was a true community supporter. He always made me feel I am doing valuable work when sharing my knowledge. And that I should always try to contribute more to the community. Next week is the Oracle CloudWorld in Las Vegas. The first time for a long time the community gets together, invited by Oracle. Joel would appreciate this. It still hurts to realize he will not be there. I am excited to meet so many friends after all these years, and so looking forward making new friends. The community is ..read more

Joel Kallman was one of my favorite persons at Oracle and I can honestly say I miss him a lot. There are no words to express my appreciation on Tim Hall’s suggestion to dedicate October 11th 2021 to Joel. I decided not to write a tech tip but to tell you about the blog post I wrote a while ago. This is the last project I worked with Joel. When I was done with the first version of the post, I sent it to Oracle for comments. I got the commented version back when Joel was already gone. Those comments included also his comments. Those who knew Joel know how polite those comments were. He was alwa ..read more

While generating the DDLs for the table you can also generate the REST services for the table easily. To generate the DDL select File, Export, DDL File. Then select the RDBMS Site and the relational model wanted and press Generate. Select Generate REST Services. And the script now not only includes the table generation (and whatever else you chose) but also REST enabling scripts. P.S. If you want to isolate the tables from users with views, you can easily create a view for a table (and then grant privileges to views instead of tables). Just like described above you can create the REST serv ..read more

Thank you, Tim Hall (oracle-base.com), for the OGB Appreciation Day! First of all I am thankful for the people like Tim and for the people at Oracle who do not care if it’s Saturday or Sunday, they just want to help me to be able to use Oracle products better. I want to mention two names particularly: Jeff Smith and Joel Kallman. There has been several weekends I have been struggling with the weirdest problems, and in 5 min they have been helping me to solve it. Thank you! This community, including customers, partners and Oracle, is just amazing!   Then about the technology. Today I am extreme ..read more

Dear reader, my sincere apologies for the slow replies on your questions. I have been too busy with my work, travelling, speaking, studing, teaching and researching. I will try to improve. Please keep asking and I’ll do my best to reply.   Oracle SQL Developer Data Modeler 19.2 is out. Just like SQL Developer, Oracle Instant Client and many other Oracle products 19.2 version is not supported on Windows 7. So if you are still a Windows 7 user, you might want to upgrade to Windows 10. If that is not possible, consider using version 18.2 of these products until you are ready to upgrade. I persona ..read more