I have Table with values XYZ ----- 1abcP 1defQ I need a normal query (not pl/sql) which开发者_运维知识库 can give result as
This question already has answers here: Closed 11 years ago. Possible Duplic开发者_如何转开发ate:
can we make multiple rows as comma seperated开发者_如何学JAVA in SQL Query? query should return something like:
This question already has answers here: How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
Would it be possible to construct SQL to concatenate column values from multiple rows? The following is an example:
I have 3 tables called: Applications (id, name) Resources(id, name) ApplicationsResources (id, app_id, resource_id)
I have a table a开发者_开发百科nd I\'d like to pull one row per id with field values concatenated.
How to 开发者_如何转开发aggregate string( concatenate) with Oracle 10g SQL?You could try the collect function:
I\'ve got a load of materialized views, some of them take just a few seconds to create and refresh, whereas others can take me up to 40 minutes to compile, if SQLDeveloper doesn\'t crash before that.
加载中,请稍侯......