meta user
network profile
| bio | website | |
|---|---|---|
| location | Berlin, Germany | |
| age | 30 | |
| visits | member for | 1 year, 3 months |
| seen | May 21 at 7:30 | |
| stats | profile views | 13 |
|
May 21 |
awarded | Caucus |
|
Feb 28 |
comment |
Return a fully dynamic table from an Oracle function I have to check but it has virtually no documentation thus making it unusable. |
|
Feb 28 |
comment |
Return a fully dynamic table from an Oracle function Me too but I am on Oracle :-( |
|
Feb 28 |
comment |
Return a fully dynamic table from an Oracle function Hi Chris, thanks for the answer. I have already abandoned the dynamic table because it is simply not possible. XML is too verbose but a good idea. My main problem is that I would need to call a static Java function to query a lucene index. This would mean that I need to open and close the index every time. This is very unefficient. I have resorted to a REST service with JSON and XML output. |
|
Feb 18 |
awarded | Disciplined |
|
Feb 14 |
awarded | Notable Question |
|
Feb 9 |
awarded | Yearling |
|
Jan 28 |
comment |
Disabling “SHOW TABLES;” on mysql @Phil, one would see those table anyway where he has read access. |
|
Jan 24 |
comment |
Factoring out subselect (with clause) ends in ORA-00904 Thanks for the analysis. Leigh's last tip made it work. Concerning your last remark. I have shortened the table names for the sake of brevity. |
|
Jan 24 |
revised |
Factoring out subselect (with clause) ends in ORA-00904 added 1084 characters in body |
|
Jan 24 |
comment |
Factoring out subselect (with clause) ends in ORA-00904 Leigh, you are a genius. That did the trick. See edit please and adapt your answer, I will accept it then. |
|
Jan 24 |
comment |
Factoring out subselect (with clause) ends in ORA-00904 @miracle173, please see my edit above. Thanks! |
|
Jan 24 |
revised |
Factoring out subselect (with clause) ends in ORA-00904 added 599 characters in body |
|
Jan 24 |
comment |
Factoring out subselect (with clause) ends in ORA-00904 Done, see question edit! |
|
Jan 23 |
comment |
Factoring out subselect (with clause) ends in ORA-00904 @dezso, shame on me. I pasted the wrong query. Now the correct query is in the question but the problem still remains. |
|
Jan 23 |
revised |
Factoring out subselect (with clause) ends in ORA-00904 deleted 87 characters in body |
|
Jan 23 |
revised |
Factoring out subselect (with clause) ends in ORA-00904 added 93 characters in body |
|
Jan 23 |
comment |
Factoring out subselect (with clause) ends in ORA-00904 Hi Leigh, thanks for your feedback. What problem poses the mising of styles? I have rewritten the query but still getting the same error message. Se my edit of the question. |
|
Jan 21 |
asked | Factoring out subselect (with clause) ends in ORA-00904 |
|
Oct 19 |
accepted | Using the same sequence twice in a PL/SQL statement |
