Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases?

Na predstavitvi želim deliti izkušnje in zaključke, do katerih sem prišel pri uporabi AJAX-a (Asynchronous JavaScript And XML) pri različnih scenarijih tekom razvoja APEX aplikacij.

Klasične Oraclove tabelarične funkcije lahko vračajo vnaprej določen nabor stolpcev, ki je opredeljen s tipom rezultata. Vendar v nekaterih primerih ne vemo vnaprej, katere stolpce bo funkcija vračala.

So, you create an awesome APEX application and send it out into the world... do you ever wonder how it's being used?

The database is one of the most important assets to your application. Besides being one of the most important assets it is also one of the most expensive parts in your application. Most organizations don’t get the most out of their database license and treat it like a simple bit bucket. The modern Oracle database can do so much more than just store data.

Kako smo z APEX rešitvijo na področju HRM strankam pomagali, da lažje sestavijo prave kompetence za uspešno izvedbo projekta.

We should be careful with mixing SQL and PL/SQL. The context switches between both engines can quickly kill performance. For quite a long time now Oracle supports bulk operations in PL/SQL, minimizing these context switches when executing SQL from PL/SQL.

Do you like working from the command line in sqlplus? Then you will love doing so in SQLcl. You don't like working from the command line, but have to? Then you will like it a lot more in SQLcl.