Shulou(Shulou.com)05/31 Report--

This article focuses on "what are the new features of Oracle 20c". Friends who are interested may wish to have a look. The method introduced in this paper is simple, fast and practical. Let the editor take you to learn "what are the new features of Oracle 20c"?

In Oracle Database 20c, Oracle brings the super enhancement of SQL-the SQL macro (SQL Macro) feature.

The SQL macro feature allows developers to implement complex processing through macro definitions, which can then be invoked anywhere in the SQL. The implementation of this feature is similar to the Function in SQL feature implemented in 12c.

SQL macros support two types:

Scalar-Scalar

Table-Table

Scalar expression, which can be used in SELECT list, WHERE / HAVING, Group BY / Order By, etc.

Table mode can be used in FROM statements.

The SQL capability of Oracle 20c is being greatly enhanced

At this point, I believe you have a deeper understanding of "what are the new features of Oracle 20c". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.