List of Contributions

Hello. I have an interesting query issue that is only occurring in our PROD instance. I don't think the issue has to do with our recent go-live with PUM 36 and PT 8.62 since the query runs fine in test instance. Specifically, when entering the wildcard value (%) in the prompt field and then running the ...

Hi Daron, I just took a look at my query and found the issue was because of A.DESCRLONG and C.DESCRLONG. I've removed them and now the listagg works as expected. Thanks for your help. ------------------------------ Pheng Xiong Ph.D. Senior Associate Registrar Rochester Institute of Technology ...

Hi Daron, Here is my full SQL: SELECT B.ACAD_GROUP, B.SUBJECT, B.CATALOG_NBR, A.CRSE_ID, A.COURSE_TITLE_LONG, A.DESCRLONG, A.COMPONENT_PRIMARY, E.DESCR, C.DESCRLONG, B.SSR_CRSE_TYPOFF_CD, B.CAMPUS, CASE WHEN A.UNITS_MINIMUM = A.UNITS_MAXIMUM THEN TO_CHAR( A.UNITS_MINIMUM | | '.00') WHEN A.UNITS_MINIMUM ...

I'm working on a query to identify a list of courses in the course catalog with a GE course attribute (CRSE_ATTR). I created a LISTAGG expression to list the Course Attribute Value (CRSE_ATTR_VALUE) all on one row instead of multiple rows, but I am getting a CLOB error message. Here is my expression: ...

Thank you, Daniel. That seems to have worked. I didn't think about a subquery. ------------------------------ Pheng Xiong Senior Associate Registrar Rochester Institute of Technology ------------------------------ Message from the HEUG Marketplace: ------------------------------ Find, Review, ...