AOUG presentation: JavaScript, CSS and jQuery in APEX 19c

Posted on 16 May 2019 by Przemysław Kantyka

We presented an interested topic on the Austrian Oracle User Group event: AOUG Anwenderkonferenz 2019 – “Vienna calling. Technical but fun!”. The presentation title was “JavaScript, CSS and jQuery in APEX 19c” and it describes how to go beyond declarative options of Oracle APEX.

You can review a sample application on https://apex.oracle.com/pls/apex/ (workspace: datacons, username: datacons, password: datacons) and you can run it at https://apex.oracle.com/pls/apex/f?p=124894. The presentation and source code of the sample application can be also downloaded here.

Posted in Nieokreślona | Comments Off on AOUG presentation: JavaScript, CSS and jQuery in APEX 19c

APEX 19c in AWS Amazon Cloud

Posted on 6 April 2019 by Przemysław Kantyka

APEX 19c is already available in AWS Amazon Cloud. See more at https://aws.amazon.com/marketplace/pp/B07QC2LMM2

News in this AMI release:

  • Oracle Application Express is upgraded to version 19.1c (19.1.0.00.15) and license and documentation links in Amazon Marketplace were updated accordingly. For more details: see Product Overview at https://aws.amazon.com/marketplace/pp/B07QC2LMM2
  • Default APEX Instance ADMIN password generation on initial boot was changed to be based on Machine Instance ID. For more details: see Usage Instructions at https://aws.amazon.com/marketplace/pp/B07QC2LMM2
  • Default disk size, during launch of AMI, was increased to 25 GB

See also Oracle APEX 19c Release Notes

Posted in Nieokreślona | Comments Off on APEX 19c in AWS Amazon Cloud

JavaScript, CSS and jQuery in APEX 19c

Posted on 5 April 2019 by Przemysław Kantyka

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

Posted on 28 March 2019 by Przemysław Kantyka

We enabled APEX 18c to the Amazon Cloud

Whenever you want just to try the newest APEX for only one hour or you need hundreds of APEX instances for months – with the AWS Cloud (and us :)) – you can! Full pre-configured stack of software: Oracle DB, APEX, ORDS, Tomcat and Nginx on dedicated secured instance is ready for you in less than 10 minutes.

Check more at https://aws.amazon.com/marketplace/pp/B07NDJFCVV

Continue reading →

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

Oracle XE 18c is available for download

Posted on 27 October 2018 by Przemysław Kantyka

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 data, 2GB of RAM and 2 cores
– a lot of new options disabled in 11g XE are now available for example: compression, spatial, partitioning, multitenant/pluggable databases, advanced analytics

Don’t wait and download Oracle XE 18c now.

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

Oracle APEX 18.2c is available for download

Posted on 29 September 2018 by Przemysław Kantyka

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 interface. See new features at https://docs.oracle.com/database/apex-18.2/HTMRN/toc.htm#HTMRN-GUID-D6D545CB-3ECD-468A-9E7F-8CC09F7F478B and all features at: https://apex.oracle.com/en/platform/features/

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

New Oracle APEX 5.2 for Christmas!

Posted on 25 December 2017 by Przemysław Kantyka

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 whole lot more

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

Free Oracle APEX training course materials

Posted on 31 May 2017 by Przemysław Kantyka

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 may use these materials in your training courses or curriculum.

Free Oracle APEX training

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

What Developers Should Know … Part 3

Posted on 26 January 2017 by Radosław Cisz

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

We can say, that variables used inside PLSQL block are “Automatic Bind Variables”. So it means they are considered as bind variable and are not causing parse operations. That it is better to run stored PLSQL block then a lot of single SQL queries from application (from database point of view)
Continue reading →

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

What Developers Should Know … Part 2

Posted on 25 January 2017 by Radosław Cisz

Up to now, we talked about

  • Selectivity / Cardinality
  • Skewed Data / Histograms
  • Displaying Execution Plans with Explain Plan, dbms_xplan package, autotrace feature
  • Introduced bind variables

I believe, that for most of you it was quite familiar..

But I also stronlgy believe, that we should talk about the process of executing SQL query and components of Oracle Database that take part in it…
Continue reading →

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