(Flavio Casetta) As per Oracle 12.2 SQL Reference:
Other News
Native Oracle DB JSON functionality as alternative for using cursor() in AOP (and APEX_JSON)
(Dimitri Gielis) When using external (WEB/REST) services, you often communicate in JSON. So it’s important to be able to generate JSON in the format that is expected by the external service.
Change time zone in Oracle’s DBaaS
(Marco Mischke) Recently I assisted in a project that is utilizing Oracle Cloud Infrastructure (OCI) to provide application servers and Oracle databases. The customer is located in New Zealand, so they obviously wanted to work with dates and times in their local time zone.
SQL SERVER Management Studio – Enable Statistics Time and IO for Every Query
(Pinal Dave) Recently, while working with a large education institute on Comprehensive Database Performance Health Check I was asked a very interesting question about statistics TIME and IO for SQL Server Management Studio, let us discuss that in today’s blog post.
JavaScript Export to Excel HTML Table with Input Tags
(aditya pewekar) This tip gives a brief of how to export a HTML table with input tags into Excel file using JavaScript.
AI-powered Search with spaCy — Part 4
In the previous articles in this series, you learned how interrogative sentences of the most common types can be parsed, allowing you to extract the most descriptive words from a sentence to be used then for a search for a relevant answer. In other words, you learned to implement the ability to understand what the user is asking about or...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
How to test for query regressions when upgrading
(Denny Cherry) One of the things that you want to test for when doing an upgrade of SQL Server is query regressions. Regressions happen when the new version of SQL Server makes a poor decision when running the same code that you can before.
Debugging 3rd Party .NET Code without symbols in Visual Studio
(Michael Shpilt) It’s not so rare to see weird things happen in 3rd party library code. Call some method and you’ve got a strange exception.
Localisation in ASP.NET Core Razor Pages – Cultures
(Mike Brind) This is the first in a series of articles that explores localisation in ASP.NET Core Razor Pages applications. This article will look at the configuration required to prepare a site for content localisation, in other words, to globalise the site. Future articles will cover the creation
Algebraic Data Types: Things I wish someone had explained about functional programming
(James Sinclair) Algebraic data types and algebraic data structures sound similar. It’s like they ought to be the same thing. But they’re not. They both have ‘algebraic’ in the name, so it’s confusing.