Blog: Sayan Malakshinov


209 blogs updated: 19 min. ago
Book advice: ORACLE SQL & PL/SQL Golden Diary by Asim Chowdhury
I've reviewed this book recently, and I highly recommend it as it has almost all that needed to become strong Oracle developer. You can chec...
9
10-08-2017 13:38:02 Sayan Malakshinov Oracle
SQL validation during PL/SQL compilation
A recent posting on SQL.RU asked why Oracle doesn't raise such errors like "ORA-00979 not a group by expression" during PL/SQL compilation. ...
15
01-05-2017 01:41:06 Sayan Malakshinov Oracle
Intra-block row chaining optimization in 12.2
I've wrote in previous post 4. Next row piece can be stored in the same block only with inserts. When you run update, oracle will place new ...
12
21-04-2017 04:45:10 Sayan Malakshinov Oracle
How to speed up slow unicode migration of a table with xmltype columns
Recently I have had an issue with slow unicode migration of the database upgraded from 10g to 12.1.0.2. The main problem was a table with xm...
16
20-02-2017 02:54:32 Sayan Malakshinov Oracle
row pieces, 255 columns, intra-block row chaining in details
You may know about Intra-block row chaining which may occur when the number of columns in a table are more than 255 columns. But do you know...
20
12-02-2017 03:55:54 Sayan Malakshinov Oracle
How even empty trigger increases redo generation
Very simple example:
3
22-09-2016 01:21:33 Sayan Malakshinov Oracle
8 queens chess problem: solution in Oracle SQL
This is just another solution of this problem for a chessboard, but you can choose any size of the checkerboard: It works quite fast: 8*8 0....
15
13-06-2016 11:43:40 Sayan Malakshinov Oracle
8 knights chess problem: solution in Oracle SQL
This is just another solution of this problem for a chessboard, but you can choose any size of the checkerboard: It works quite fast: 8*8 0....
3
13-06-2016 05:07:35 Sayan Malakshinov Oracle
Maven: how to copy files after a build into several distribution directories
Sometimes it is convenient to copy jar-files automatically after a build into several different directories, for example if you have differe...
3
12-05-2016 01:45:18 Sayan Malakshinov Oracle
WINDOW NOSORT STOPKEY + RANK()
Recently I found that WINDOW NOSORT STOPKEY with RANK()OVER() works very inefficiently: The root cause of this behaviour is that Oracle opti...
3
12-03-2016 01:02: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.