357 reputation
314
bio website
location
age
visits member for 2 years, 3 months
seen May 15 at 16:09
stats profile views 84

May
10
awarded  Notable Question
Apr
7
awarded  Popular Question
Feb
11
awarded  Popular Question
Dec
21
comment Generating an arithmetic sequence
interesting idea... would definitely work, though I think I preferred Vincent's answer for this one, thanks.
Dec
21
comment Generating an arithmetic sequence
Thanks, the CONNECT BY was exactly what I was trying to find.
Dec
21
accepted Generating an arithmetic sequence
Dec
20
comment Generating an arithmetic sequence
thanks, let me check it out & see...
Dec
20
revised Generating an arithmetic sequence
deleted 4 characters in body
Dec
20
revised Generating an arithmetic sequence
added 29 characters in body
Dec
20
asked Generating an arithmetic sequence
Dec
12
revised Select Count(*) FROM with-clause-named table order by a, b not working
added 398 characters in body
Dec
12
accepted Select Count(*) FROM with-clause-named table order by a, b not working
Dec
12
comment Select Count(*) FROM with-clause-named table order by a, b not working
actually this may be working after initially testing it and asking only for columns defined in the group by... let me try to complete the whole query and let you know if it works... Thanks!
Dec
12
comment Select Count(*) FROM with-clause-named table order by a, b not working
yes there are more columns in the derived table t. Do I need to do something with with the group by ColumnC, ColumnD? Let me try that out...
Dec
12
revised Select Count(*) FROM with-clause-named table order by a, b not working
added 6 characters in body
Dec
12
revised Select Count(*) FROM with-clause-named table order by a, b not working
added 4 characters in body
Dec
12
asked Select Count(*) FROM with-clause-named table order by a, b not working
Oct
24
comment Simple query with date type requires explicit conversion to_date of date
Thank you for the contribution as well, in the final query version, have noted the intricacy of the midnight setting of the to_date... the major issue was that the table had a fundamentally outdated date formatting style...
Oct
24
comment Simple query with date type requires explicit conversion to_date of date
you know, a lot of programmers now were not around to fix programming issues in 2000.... So I foresee a repeat in 2100, good eye.
Oct
24
revised Simple query with date type requires explicit conversion to_date of date
added 719 characters in body