Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Connor McDonaldabout wm_concat() in 12c
Hi tom,when i tried use this wm_concat() function in 12c i'm getting this error can you briefly explain?ORA-00904: "WM_CONCAT": invalid identifier00904. 00000 - "%s: invalid identifier...
Chris Saxon12c attribute clustering vs old index cluster
Hi,The attribute clustering works only for the direct path inserts? Will it support the normal inserts? If not whats the way to have the data in table stored in an ordered way especially for normal inserts (not direct path).Can you explain whether index cluste...
Chris SaxonSplit Records into Groups of N Rows
Got a SQL from the table with 100,000 + records , one particular varchar2 field contains strings like '12345', '56789', '1111'. I would like to create a table with split / chunks with appropriate comma seperate example in the live link ::: select listagg(id, '...
Connor McDonaldHow to improve Oracle data extraction throughput rate
For the last 17 years I've been focused on real-time apps where the number of rows retrieved from Oracle is usually 1 and almost always less than 10. I have a good reputation in being able to write very performant real-time applications, but suddenly I'm face...
Connor McDonaldrestore single table from rman full backup
Hi I have a rman full backup and I want to restore single table due to drop that table how can I do this.I can not create a clone due to space and resources issue..Thanks...