137 reputation
16
bio website localhost
location United States
age 38
visits member for 3 years, 4 months
seen Dec 16 at 20:02

Full time J2EE & Jave EE developer / Part time PhD candidate
I am really keen on computational linguistics.


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)
Aug
25
awarded  Supporter