Ask The Oracle Mentors

Recently Answered

	about 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...
	12c 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...
	Split 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, '...
	How 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...
	restore 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...