Sergey Averin, Author at {coding}Sight

Home

Author: Sergey Averin

Sergey is a developer of Delphi applications for large databases and server logic for such applications. He mainly focuses on such databases as Oracle and Firebird. Has a deep knowledge of SQL and PLSQL. Sometimes Sergey writes programming related articles.

Oracle as Workaround of Mutating Tables

October 02, 2017• 13:47• Computer Environment, Database development, Tables

The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger,...

Read More →

Oracle Regular Expressions. Dangerous Range

September 29, 2017• 15:25• Computer Environment, Database development, Statements

An Oracle developer who often uses regular expressions in code sooner or later can face a phenomenon that is indeed mystical. Long-term...

Read More →

↑

Close

Introduction to Temporary Tables in SQL Server June 26, 2017
Calculating Running Total with OVER Clause and… March 16, 2018
Grouping Data using the OVER and PARTITION BY Functions February 16, 2018
Methods to Rank Rows in SQL Server: ROW_NUMBER(),… December 08, 2017
Passing Data table as Parameter to Stored Procedures October 24, 2018