the following is an interesting puzzle posted by jsoftware
arrange a list of distinct positive integers so that no two numbers have their average between them in the sequence.
column input format a10
column reason format a60
variable input data varchar220
exec input data 1234
check if two number have their average between them in the sequence
select input data input
prior n is placed between... [Show More]
the following is an interesting problem posted by jsoftware
find all occurrences starting positions of the input string as a substring in the data.
create table t9 as
select 1 id 1hihihi8hihihi as str from dual
union all
select 2 id hihihi7hihihi as str from dual
column str format a30
column start position format a30
variable input varchar2100
exec input hihi
overlapping substrings sql solut... [Show More]
the following is an interesting problem posted by jsoftware
given a string of words separated by blanks and a positive integer w of the desired width. replace appropriate blanks in the string by the newline character so that lines are no wider than w and each line contains all the words that fit within the line.
to focus on essentials assume words are at most w in length adjacent words are separat... [Show More]
the following is an interesting puzzle posted by jsoftware
determine all the times whose display on a 24hour clock is a prime number.
sql solution
select
cas e lengthnum
when 3
then substrnum0 1substrnum 22
else substrnum0 2substrnum 32 end clock 24 hr
from
with data as select level1 num from dual connect by level...... [Show More]
the following is an interesting problem posted by jsoftware
with n people numbered 1 to n in a circle every second one is eliminated until only one survives. determine the elimination order and the survivors number.
sql solution
variable input num number
exec input num 10
set timing on
select trimboth from regexp replacexml aggxmlelem entx
case when iteration is not null then dat... [Show More]
r is for r Post Source: ananelson.com Posted: Nov 11 2007 17:31:39
n i accidentally typed n into google the other day. i meant to type n into my address bar to bring up news.google.ie but i typed it into the search box instead and found myself staring at the first entry on the results page before i realised my mistake. it had the enigmatic title n puzzleplatformer with physics and style so i had to click. n turned out to be a nifty little game written in actions... [Show More]
miscellania Post Source: recursivepizza.livejournal.com Posted: Apr 03 2006 13:23:05
since i havent posted in such a long time heres a hodgepodge of snippets from my life for anyone whos interested to know what im up tospurred by my nationalch ampionhept athleteand threetimea llamerican volleyball star wife i have begun swimming three mornings a week theres a newlyrenovated public pool directly across the street from our apartment which is free for dc residents so i really have absolute... [Show More]
Feeds and posts are not affliated with ://URLFAN. They are displayed here simply for informational purposes, if you would like to remove your feed please contact us.
E-mail me
Activate 
