Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 7
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
Feb
25
awarded  Popular Question
Aug
18
awarded  Notable Question
Feb
11
awarded  Popular Question
Jun
13
accepted Using wm_concat to concatenate rows, but in an order determined by another column
Jun
4
answered Using wm_concat to concatenate rows, but in an order determined by another column
Jun
4
comment Using wm_concat to concatenate rows, but in an order determined by another column
@bluefeet Yeah thanks a bunch. I think that is the sort of approach we are going to have to go with. I am going to write an answer and you can write an answer if you like.
Jun
4
comment Using wm_concat to concatenate rows, but in an order determined by another column
Oh my, 4000 chars is all I get? Well my concatenation is definitely longer than that.
Jun
4
comment Using wm_concat to concatenate rows, but in an order determined by another column
@bluefeet - Yes I do, I guess I have never used it before. Now, I have figured out how to manipulate the above to use listagg instead of wm_concat. The new problem I get is a ORA-01489 result of string concatenation is too long. Gotta look into this before I can share my final query.
Jun
4
asked Using wm_concat to concatenate rows, but in an order determined by another column
Aug
21
awarded  Analytical
Feb
3
comment ORA-01031 Insufficient Privileges Raised From Within Function
I am going to go bang my head against a sufficiently thick block of concrete. I just had the owner of the procedure incorrect ... I was assuming it was someone else. Granting to the correct user solved my problem. Thanks.
Feb
3
accepted ORA-01031 Insufficient Privileges Raised From Within Function
Feb
3
asked ORA-01031 Insufficient Privileges Raised From Within Function
Sep
29
comment How can I alter the output for the sql desc command?
I see, I have to ultimately make it over to the user_indexes table. Thanks! It is a nice extension of the standard desc available to me.
Sep
29
accepted How can I alter the output for the sql desc command?
Sep
28
comment How can I alter the output for the sql desc command?
Yeah, I was thinking that might be what was tripping me, but alas I get 0 rows either way with the query above. However, you did jog my mind and I see I was not logged in as a user with sufficient enough permissions. I now get 10 rows with that query, so that solves expanding the returned columns. However, I still do not see how I can list if a column is UNIQUE or not
Sep
28
asked How can I alter the output for the sql desc command?
Aug
25
awarded  Student
Aug
25
awarded  Scholar
Aug
25
accepted Shortest Query to Combine Count and Unique (Oracle)