Morning Cup O' Joe

Time you enjoy wasting isn't wasted time.

Solving a Sudoku with Oracle


Being a database developer, I’ve seen some fairly interesting things you can do with Oracle 11g.

This beats everything I know thus far.

Oracle RDBMS 11gR2 introduced a new feature called Recursive Subquery Factoring. Besides being an alternative to hierarchical queries (classic “connect by” stuff), you can use it to solve a Sudoku…in 29 lines of SQL code.

Mind = Blown

Thanks for the link, Alex!

via Amis Technology Blog (Sudoku)

via Rob Van Wijk


September 20, 2012 - Posted by | How-To, Software | , , , , ,

Sorry, the comment form is closed at this time.

%d bloggers like this: