Morning Cup O' Joe

Time you enjoy wasting isn't wasted time.

Solving a Sudoku with Oracle

250px-sudoku-by-l2g-20050714_svg

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

About these ads

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

Sorry, the comment form is closed at this time.

Follow

Get every new post delivered to your Inbox.

Join 98 other followers

%d bloggers like this: