Category Archives: Oracle

Funkcja agregująca COLLECT – część pierwsza

W tym wpisie przyjrzymy się funkcji agregującej COLLECT. Funkcja ta przyjmuje jako argument kolumnę, zwracając w wyniku zagnieżdżoną tabelę dla każdej grupy, po której odbywa się grupowanie. Tabela ta zawiera wiersze złożone z wartości kolumny, która została podana jako argument. Wiersze zawarte … Continue reading

Posted in Oracle, Oracle APEX, Oracle SQL, Oracle SQL Zaawansowany | Tagged , | Comments Off on Funkcja agregująca COLLECT – część pierwsza

Load Balancer with Oracle APEX in the Amazon Cloud (AWS)

See how to run Oracle APEX with Elastic Load Balancing in Amazon AWS to leverage traffic and balance your workload to multiple ORDS instances. Continue reading

Posted in Amazon AWS Marketplace, AWS, Oracle APEX, Oracle APEX Advanced, Oracle DBA | Tagged , , , , , , | Comments Off on Load Balancer with Oracle APEX in the Amazon Cloud (AWS)

svnAPEX BETA demo server is public now

We’ve published svnAPEX BETA version (aka APEX Version Control) on our public DEMO server. svnAPEX allows you to follow industry standard workflow and increase efficiency of your APEX development process by integration the Application Builder with SVN version control system. … Continue reading

Posted in Oracle APEX, Oracle APEX Advanced | Tagged , , , , , , | Comments Off on svnAPEX BETA demo server is public now

JavaScript, CSS and jQuery in APEX 19c

We have been on OUG Irealand 2019 and we presented very interesting topic about going beyond APEX declarative options:  “JavaScript, CSS and jQuery in APEX 19c“. Here you can download our presentation and Sample Application with working examples.

Posted in Oracle APEX Advanced | Tagged , , , , , | Comments Off on JavaScript, CSS and jQuery in APEX 19c

APEX in the Cloud

Oracle APEX in AWS Cloud Continue reading

Posted in Oracle APEX, Oracle DBA | Tagged , , , , | Comments Off on APEX in the Cloud

Oracle XE 18c is available for download

We’ve been waiting a very long time but finally it is: New version of Oracle XE: Oracle XE 18c is available for download (only for Linux now). What is even more important: – limits are extended to 12GB of user … Continue reading

Posted in Oracle, Oracle DBA | Tagged , , , | Comments Off on Oracle XE 18c is available for download

Oracle APEX 18.2c is available for download

Oracle APEX 18.2c is available for download. Check this link: https://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html There are great new features like REST Enabled SQL, JET charts improvements, Interactive Grid improvements, JavaScript API documentation for widgets, better master-detail, improvements if APEX Font and App Builder … Continue reading

Posted in Oracle APEX | Tagged , , , , , | Comments Off on Oracle APEX 18.2c is available for download

New Oracle APEX 5.2 for Christmas!

There is APEX 5.2 Early Adopter available on https://apexea.oracle.com. Release 5.2 brings a suite of new features including REST enabled SQL, improvements to REST Service Consumption, an all new Create App Wizard, new chart types, APEX Spotlight Search, and a … Continue reading

Posted in Oracle APEX | Tagged , , | Leave a comment

Free Oracle APEX training course materials

Here you can find free APEX training for download and self learning. Package of files contains: Presentations with detailed comments Hands-on Lab Guide with description of workshops APEX source files, SQL files and data files for preparing of environment You … Continue reading

Posted in Oracle, Oracle APEX, Oracle APEX Advanced, Oracle APEX Fundamentals | Tagged , , , | Leave a comment

What Developers Should Know … Part 3

If you have read Part 1 and Part 2 of this series, you are now ready to observe parsing (soft and hard), bind peeking, influence them, and observe how Adaptive Cursor Sharing tries to fix it. Literals vs Bind Variables … Continue reading

Posted in Oracle DBA, Oracle SQL Zaawansowany | Tagged , , , | Leave a comment