Joel Kallman, Jerusalem, and the Oracle Community in Israel #JoelKallmanDay

It’s Joel Kallman Day again. And we still miss him dearly.

A place Joel loved was Israel, and especially Jerusalem. When we visited Jerusalem during the ilOUG event in July 2013, Joel said to me that his life is now complete, he always wanted to see Jerusalem. We both were quite emotional during that trip. I did my trip on behalf of my grandfather, who was never able to visit Jerusalem in person but was following my trip from home.

Joel would be very sorry to see the situation in Israel, and Jerusalem, today. He believed in peace and harmony, and wanted everybody to be friends.

The Oracle community in Israel has been strong and active for many years. That community had a special place in Joel’s heart.

I hope the ilOUG and the whole Oracle Community in Israel are safe and will remain safe. I wish you a peace in the country, soon. Stay safe.

Oracle CloudWorld, the Community, and the ACE Program #JoelKallmanDay

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 extremely important and makes the techie life even better: computers are fun but even more fun when you can share the feeling with other people. Another important part of the event is hearing what’s coming next on the Oracle space and what people have done using the Oracle technology, the techie part itself.

Of course, I will do my part of sharing the knowledge too. I will be talking about one of my favorite topics: machine learning. Machine Learning in the Cloud – Without Any Panic. I want to talk about this topic because I have realized many people are curious and interested in machine learning but worried about the complexity of it. What if I cannot understand machine learning? What if it is too difficult for me? In my session I will explain the features Oracle has created in the Oracle Cloud Infrastructure (OCI) to make using machine learning as easy as possible. And it is easy. There is no reason to panic and worry, you will be fine with machine learning. And to remind: the community is there to help you, if any problems. You can always ask for advice or guidance if you think you do not know what to do next.

I will also attend an Oracle ACE Program Roundtable with Jennifer Nicholson (Director, ACE Program Management, Oracle) to discuss how an individual can contribute to the community. We will discuss about the Oracle ACE Program, Oracle’s premier community program that recognizes & rewards individuals for their contributions to the Oracle community. Oracle ACEs love sharing their knowledge and helping the Oracle community, and therefore the ACE Program is an important part of the community. There are many ways you can contribute: you can write blog posts or books, speak, mentor…Whatever feels comfortable to you. And guess what, you do not only feel good when helping others, you will also learn a lot! And you will make amazing friends!

I hope to see many of you at the CloudWorld, or any of the other amazing Oracle Community events during this year or the years to come. Being a techie is fun, but being a techie with a supporting community is so much more fun!

#JoelKallmanDay

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 always so kind and caring. Reading and editing his comments was heartbreaking.

I want to dedicate this blog post to Joel. I miss you, my friend. Thank you for everything!

https://blogs.oracle.com/database/post/covid-19-tracking-app-finland

Generate REST services

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.

ddl

Then select the RDBMS Site and the relational model wanted and press Generate.

ddl2

Select Generate REST Services.

ddl3

And the script now not only includes the table generation (and whatever else you chose) but also REST enabling scripts.

ddl4

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 services for views as well.

To create the views for tables select Tools, Table to View Wizard.

view

Select the tables wanted.

view3

And then generate the DDLs as described.

view2

 

OGB Appreciation Day: free cloud and people

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 extremely thankful for the Always Free Services! This is an amazing offer from Oracle! Thank you!

cloud.oracle.com/free

 

Thank you! #ThanksOGB

Heli

I am so sorry for not responding your questions and something about Windows 7

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 personally know that you will have problems with Win7 and SQL Developer 18.3+/Instant Client 19 and that they work perfectly well on version 18.2 on Win7 so it is possible that Data Modeler might have some issues as well on Win7.

 

Best regards,

Heli

ODC Appreciation Day: Oracle SQL Developer Data Modeler

I know this is too obvious coming from me but Data Modeler is my favourite tool and I use it every single day. Without Data Modeler I could not do my work and design databases well and efficiently and without it I could not show other people how easy and important it is to design databases. 18.3 just came out and it is ever better than the previous versions!

https://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Thank you ODC for Oracle SQL Developer Data Modeler!

Finding objects that have a certain property “null”/”empty”

How can I find all the tables in SQL Server 20112 physical model that has the Text image  defined empty?

Right-click on the Browser on the physical model you want to search. Select Search. Select Advanced Mode. Select Table, press Add Property and select Text image fg as a property. Press Search.

TextImage

These are all the tables having Text image property null/empty.

The same works for any searches on logical, relational or physical property searches.

 

Setting a property to “empty” for several objects

In many cases I need to find those properties that are not “empty” and set the property to “empty” to all of those. One example is when I’m desiging a data warehouse and the source tables (which I will reverse engineer as a base for the DW tables) have default values. I do not want to have default values for my DW!

Let’s see an example.

First I need to find the entities (all tables or physical tables) that has a default value.

Start Search either by pressing the Search icon in the Tool bar or right-click on the Browser on the logical model and select Search.

Select Advanced Mode. Select Attribute. Press Add Property. Select Default value. Choose Not.

Empty

And press Search.

Empty2

Then press Properties.

Empty3

Select Default value and press the arrow pointing to left, select “empty string”. Press Apply.

Empty4

Now the default value property for all the attributes listed as Serach result have been updated to empty.

 

Empty5

You can use this same method for changing any properties of logical, relational or physical model to empty.

 

 

 

 

Oracle SQL Developer Data Modeler 17.4

This is a version I have been waiting: so many important bug fixes! I downloaded it immediatelly the evening it was available and finished one of my projects using it.

If you have not downloaded it yet, do it today: http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Why did I waited for it? Because of, for instance, these bug fixes:

27245333 – IMPORT OF DDL AS ORACLE 12CR2 DOESN’T RECOGNIZE DATA TYPES
27182476 – SQL SERVER 2012 DDL GENERATION FAILS WITH CLASS CAST EXCEPTION
26985782 – STANDARD REPORT – COLUMN DATA TYPE IS NOT INCLUDED WHEN COLLECTION
27040952 – DESIGN PROPERTIES DIALOG DOESN’T WORK
26988362 – IMPORTING LEGACY PHYSICAL MODEL RESULTS IN TABLE ITEMS LISTED RED IN HIERARCHY
27041167 – REVERSE CLAUSE FOR INDEX IS NOT PROCESSED DURING IMPORT FROM DATABASE
26918584 – SYNC TO DB CANNOT RECOGNIZE TABLES WHEN PROXY USER IS USED
26919656 – PROBLEMS WHEN EDITING UDP FOR ATTRIBUTES IN ENTITY DIALOG
26750611 – INVALID INSERT STMT ON ‘USE QUOTED IDENTIFIERS’ CHECKED AT DDL PREVIEW SCRIPT
26920080 – “INCLUDE SCHEMA IN DDL” SETTING IS NOT CONSIDERED FOR PROCEDURES
26932946 – ANNOYING BEHAVIOR WHEN CREATING COLUMNS