Get the App
SLTechnology News&Howtos  ›  Database  › 

What are the new features of Oracle 20c

Shulou Source: shulou.com Published: 2022-05-31 15:41:16 11月16日 Update

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!

Tags: Features content scalars statements learning complexity utility deeper people location interest practicality practicality simplicity of operation way method more friends being type Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Linux Microsoft Shulou Information Redmi Docker