Puzzles on SQL/Oracle

DA Morgan wrote:
> Rene Nyffenegger wrote:
> > On 2006-12-23, nirav wrote:
> >> Hello,
> >>
> >> How about Games Programming like chess programming or Tic-tac-Toe or
> >> other games etc using SQL or Pl/SQL...has this been done?? I mean some
> >> questions like how to find out how many different moves are possible
> >> for next step in Chess or Tic Tac Toe etc is this something someone has
> >> come across??
> >
> >
> > I have once tried to create a sudoku solver in PL/SQL:
> > http://www.adp-gmbh.ch/blog/2005/september/6.html
> >
> > Unfortunately, it has a bug, but still...
> >
> > Regards
>
> Try mine:
> http://www.psoug.org/sudoku.html
>
> Though I'll not guarantee it doesn't have a flaw or twenty.
>
> And it has never seen even two seconds of optimization. Still it
> handles the newspaper puzzles subsecond.
> --
> Daniel A. Morgan
> University of Washington
> damorgan-at-x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Anyone have pl/sql Sudoku puzzle generator?

EscVector wrote:

> Anyone have pl/sql Sudoku puzzle generator?

Now that's nasty. ;-)

There was an article in Scientific American earlier this year on Sudoku
indicating, IIRC, the minimum number of provided values to achieve a
solvable puzzle is 17.
--
Daniel A. Morgan
University of Washington
damorgan-at-x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

EscVector wrote:

> Anyone have pl/sql Sudoku puzzle generator?

Now that's nasty. ;-)

There was an article in Scientific American earlier this year on Sudoku
indicating, IIRC, the minimum number of provided values to achieve a
solvable puzzle is 17.
--
Daniel A. Morgan
University of Washington
damorgan-at-x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
> EscVector wrote:
>
> > Anyone have pl/sql Sudoku puzzle generator?
>
> Now that's nasty. ;-)
>
> There was an article in Scientific American earlier this year on Sudoku
> indicating, IIRC, the minimum number of provided values to achieve a
> solvable puzzle is 17.
> --
> Daniel A. Morgan
> University of Washington
> damorgan-at-x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

I have all the known values downloaded.---
http://people.csse.uwa.edu.au/gordon/sudokumin.php
Could just plop them in a table. I'm interested in converting the code
from c++ to pl and was looking to see who might have done it.

DA Morgan wrote:
> EscVector wrote:
>
> > Anyone have pl/sql Sudoku puzzle generator?
>
> Now that's nasty. ;-)
>
> There was an article in Scientific American earlier this year on Sudoku
> indicating, IIRC, the minimum number of provided values to achieve a
> solvable puzzle is 17.
> --
> Daniel A. Morgan
> University of Washington
> damorgan-at-x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

I have all the known values downloaded.---
http://people.csse.uwa.edu.au/gordon/sudokumin.php
Could just plop them in a table. I'm interested in converting the code
from c++ to pl and was looking to see who might have done it.

EscVector wrote:
> DA Morgan wrote:
>> EscVector wrote:
>>
>>> Anyone have pl/sql Sudoku puzzle generator?
>> Now that's nasty. ;-)
>>
>> There was an article in Scientific American earlier this year on Sudoku
>> indicating, IIRC, the minimum number of provided values to achieve a
>> solvable puzzle is 17.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan-at-x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
>
> I have all the known values downloaded.---
> http://people.csse.uwa.edu.au/gordon/sudokumin.php
> Could just plop them in a table. I'm interested in converting the code
> from c++ to pl and was looking to see who might have done it.

Nice link. And I'm game to move anything from C++ to PL/SQL just for the
fun of it. Not sure when I will get to it but it does confirm my
recollection that 17 is the magic number.
--
Daniel A. Morgan
University of Washington
damorgan-at-x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

EscVector wrote:
> DA Morgan wrote:
>> EscVector wrote:
>>
>>> Anyone have pl/sql Sudoku puzzle generator?
>> Now that's nasty. ;-)
>>
>> There was an article in Scientific American earlier this year on Sudoku
>> indicating, IIRC, the minimum number of provided values to achieve a
>> solvable puzzle is 17.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan-at-x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
>
> I have all the known values downloaded.---
> http://people.csse.uwa.edu.au/gordon/sudokumin.php
> Could just plop them in a table. I'm interested in converting the code
> from c++ to pl and was looking to see who might have done it.

Nice link. And I'm game to move anything from C++ to PL/SQL just for the
fun of it. Not sure when I will get to it but it does confirm my
recollection that 17 is the magic number.
--
Daniel A. Morgan
University of Washington
damorgan-at-x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org