filmov
tv
Pattern Matching + SQL Macros = Pure SQL Awesomeness!
Показать описание
Added in Oracle Database 12c, SQL pattern matching (match_recognize) makes it easy to answer many questions that were hard-to-impossible with SQL.
But turning match_recognize clauses into reusable functions was tricky at best.
No more!
Added in 19.6, SQL macros enable you to define reusable code fragments. These return SQL that becomes part of your final SQL statement.
**********
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
This session will show you how you can combine SQL macros and match_recogize. Together these enable you to write generic functions answering common questions such as "find me all the consecutive rows".
But turning match_recognize clauses into reusable functions was tricky at best.
No more!
Added in 19.6, SQL macros enable you to define reusable code fragments. These return SQL that becomes part of your final SQL statement.
**********
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
This session will show you how you can combine SQL macros and match_recogize. Together these enable you to write generic functions answering common questions such as "find me all the consecutive rows".
0:58:04
Pattern Matching + SQL Macros = Pure SQL Awesomeness!
0:50:41
Pattern Matching + SQL Macros = Pure SQL Awesomeness!
0:07:17
Preview Pattern Matching + SQL Macros Chris Saxon | Sangam 2020
0:06:42
SQL Macros with no SQL Injection !
0:05:16
SQL pattern matching
![[Feuertips #24] -](https://i.ytimg.com/vi/4uRlU_qX8CM/hqdefault.jpg)
0:35:24
[Feuertips #24] - The power of SQL macros and more
1:01:30
Chris Saxon: Create reusable SQL expressions with SQL macros
1:03:04
Visualizing SQL Pattern Matching (MATCH_RECOGNIZE) - A Beginner's Guide
0:36:56
Oracle SQL Pattern Matching Made Easy
0:02:51
Let's Learn SQL! Lesson 106: Creating and Running Simple and Complex Macros
0:12:01
Introduction to SQL Pattern Matching in Oracle Database 12c - Part 3
0:57:04
Finding the Longest Common Substring and Gestalt Pattern Matching
0:46:42
21st Century SQL
0:02:18
Databases: How to define macros in SQL server? (2 Solutions!!)
0:26:19
Introduction to SQL Pattern Matching in Oracle Database 12c - Part 2
0:12:01
Using SQL to Create Macro Variables in SAS | Data tutorial | PROC SQL
0:48:56
SQL macros which you can use to make reusable SQL fragments Chris Saxon
0:35:11
Nicolas Stucki - Implementing a Macro
0:03:07
Using macro variables to create SQL snippets in ApexSQL Complete
0:30:18
Futuristic SQL - making the impossible possible.
0:03:25
Let's Learn SQL! Lesson 107: The Input Parameters of Macros
0:03:08
ApexSQL Complete - Using macro variables to create SQL snippets
0:22:08
Learning Nim: Creating a Query Macro
0:10:43
REGEX (REGULAR EXPRESSIONS) WITH EXAMPLES IN DETAIL | Regex Tutorial
Комментарии