Blog: Sayan Malakshinov


209 blogs updated: 6 min. ago
"Collection iterator pickler fetch": pipelined vs simple table functions
Alex R recently discovered interesting thing: in SQL pipelined functions work much faster than simple non-pipelined table functions, so if y...
7
13-12-2017 02:41:04 Sayan Malakshinov Oracle
SQL*Plus tips #8: How to read the output of dbms_output without "serveroutput on"
When "serveroutput" is enabled, SQL*Plus executes "BEGIN DBMS_OUTPUT.GET_LINES(:LI NES, :NUMLINES); END;" after each command. That's why I d...
23
09-12-2017 23:48:40 Sayan Malakshinov Oracle
Bug with integer literals in PL/SQL
This interesting question was posted on our russian forum yesterday: We have a huge PL/SQL package and this simple function returns wrong re...
12
08-12-2017 22:03:03 Sayan Malakshinov Oracle
Oracle issues after upgrade to 12.2
Sometimes it's really hard even to create reproducible test case to send it to oracle support, especially in case of intermittent errors. In...
26
23-11-2017 23:07:09 Sayan Malakshinov Oracle
Triggers and Redo: changes on 12.2
In one of the previous posts I showed How even empty trigger increases redo generation, but running the test from that post, I have found th...
23
19-11-2017 17:01:36 Sayan Malakshinov Oracle
Adaptive serial direct path read decision ignores object statistics since 12.1
On versions 11.2.0.2 11.2.0.4 Oracle uses objects' statistics to make direct path reads decision (of course, if "_direct_read_decision_st at...
16
19-11-2017 03:54:25 Sayan Malakshinov Oracle
PL/SQL functions: Iterate and keys for associative arrays
Unfortunately associative arrays still require more "coding": we still can't use "indices of" or "values of" in simple FOR(though they are a...
16
02-10-2017 01:12:16 Sayan Malakshinov Oracle
How to group connected elements (or pairs)
I see quite often when developers ask questions about connected components: Table "MESSAGES" contains fields "SENDER" and "RECIPIENT", which...
14
29-09-2017 04:53:32 Sayan Malakshinov Oracle
Ampersand instead of colon for bind variables
I've troubleshooted one query today and I was very surprised that bind variables in this query were specified with &ersand instead of :co...
16
27-09-2017 20:59:55 Sayan Malakshinov Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.