Reputation
17,922
Next tag badge:
93/100 score
20/20 answers
Badges
4 46 94
Impact
~1.7m people reached

Jul
19
comment DECODE or CASE STATEMENT for PARAMETER in WHERE CLAUSE
Also what do you mean by "parameter"? Are you referring to Toad's substitution variables starting with '&'?
Jul
19
comment DECODE or CASE STATEMENT for PARAMETER in WHERE CLAUSE
I've read this and reread it and I still can't work out exactly what you are asking. Please can you edit and clarify? For a start, who is "he" you keep referring to?
Jul
13
comment One time data conversion in Oracle tables with excel data
There is some overlap between the sites - just use your judgement to chose one or the other depending on the expertise you are seeking. Have a read of the help pages to find out what is on-topic here too.
Jul
10
revised To have PostgreSQL-like Partial Index in MySQL 5.5
edited tags
Jul
10
answered Oracle's (+) notation within function
Jul
4
revised Stored procedure using cursors
unless you say plainly that you are required to use a cursor you are being unfair to those who put in effort to give you good advice.
Jul
4
revised Could not connect to postgres after installing 9.4 and uninstalling 9.3
edited title
Jul
3
awarded  Nice Answer
Jun
30
revised SQL Server 2008 R2 Memory Pressure
appended answer 105500 as supplemental
Jun
30
awarded  Good Answer
Jun
26
awarded  Popular Question
Jun
16
revised Why does SQL Server 2005 only use an IS lock in this scenario?
edited tags
Jun
14
revised Is there a data type in MySQL similar to varchar(n) that not allow numbers or special characters in it?
deleted 2 characters in body
Jun
13
revised Special characters in Oracle utl_http request
edited tags
Jun
13
revised Best index for similarity function
edited tags
Jun
13
comment Dealing with single quotes in a dynamic query
@Colin that's a good question - as far as I can see no-one cast a close vote to migrate but perhaps that's just because they have aged away. I not usually going to mod migrate if there is no sign that's what the community wants, if that is what you are asking.
Jun
10
revised Problem forming a query with subqueries in design view? (MS Access 2010)?
title change at OPs request
Jun
9
revised Modify LISTAGG query for 10g
made question title more closely match the question body.
Jun
9
comment Modify LISTAGG query for 10g
you don't need to use subquery factoring (aka 'with' clause), I just found it convenient from the starting point you gave. It's quite possible you could do this with a single query rather than two as I have here. Not sure what any of this has to do with cursors or PL/SQL - this is a pure SQL question.
Jun
9
revised Modify LISTAGG query for 10g
added solution based on OP's SQLFiddle