(Andrejus Baranovskis) JET 6.0.0 officially supports TypeScript, wow that great news. If you are building large JavaScript application with JET, it will be much easier to manage code with TypeScript – it does type checking and reports code errors during build time.
Tag: Oracle
‘Hidden’ Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part IV” (Hallo Spaceboy)
(Richard Foote) In Part I, Part II and Part III we looked at some advantages of Global Indexes that may not be obvious to some.
The strange place for INHERIT PRIVILEGES
(Connor McDonald) A while back in an Office Hours session, I touched on a relatively new privilege in the database called INHERIT PRIVILEGES which is designed to avoid erroneous privilege escalation via AUTHID CURRENT_USER routines.
How to enable auto start/shutdown for Oracle Database 18c Express Edition on Linux
(Gerald) Oracle Database 18c Express Edition can be enabled for automatic startup and shutdown with the Linux operating system.
Using colplot to visualise performance data
(Martin Bach) Back in 2011 I wrote a blog post about colplot but at that time focused on running the plot engine backed by a web server. However some people might not want to take this approach, and thinking about security it might not be the best idea in the world anyway.
Ranges with NULLs 03: Gaps
(stewashton) When I wrote “Gaps in Date Ranges: when are you free?“, I handled NULLs using “magic” values. This time I’ll try not to cheat.
If ORA- Codes Were Buildings
(amitzil) It all started when Franck Pachot tweeted a simple tweet. The tweet was of building number 600 at Oracle offices and Franck wrote: “Dedicated to all ORA-600 friends”.
APEX client side error messages – apex.message.showErrors
(Tobias Arnhold) Since APEX 5.1 we have the ability to create client side messages without the requirement to use a plugin or custom code to create nice looking client side messages.
‘Hidden’ Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part III” (Ricochet)
(Richard Foote) In Part I and Part II of this series, we looked at how Global Indexes can effectively perform “Partition Pruning” when the partition keys are specified in SQL predicates, by only using those index entries that have a Data Object of interest stored within the index Rowids.
Running orachk as part of TFA with support tools bundle
(Martin Bach) I have previously written a number of posts about OSWatcher integration in Tracefile Analyzer (TFA) w/support tools bundle (available from My Oracle Support Document ID 1513912.1).
