Kirill Leontev

Kirill Leontev has asked 3 questions and find answers to 55 problems.

Stats

About

Kirill Leontev questions

How to handle optional parameters in SQL query?
How to stop VBA code running?
How to manually initialize a collection of RECORDs in PL/SQL?

Kirill Leontev answers

Selecting static values to union into another query
Optimizing Oracle query by removing 'exists' and 'not exists'
SQLPlus conditional execution with variable from query
drop tablespace if do not exist
Oracle Analytic functions - resetting a windowing clause
Why does the wm_concat not work here?
Getting counts/totals at each level of a hierarchical query using CONNECT BY
Excel aggregating function
SQLPLUS command line with Windows batch file
Oracle Column width for all columns