So I was handed a VERY complex script simply to turn into a pipe delimited file. The problem is that I cant seem to trim anything that used substring. for example I have tried all of these with no ...

I have a somewhat challenging SQL insert I need to accomplish in Oracle. The schema set up is not mine and it is a little weird. Here's a schema break down:<BR><BR>Table: agent<BR>agnt_id ...

Dr. Chris Hillman, Global AI Lead at Teradata, joins eSpeaks to explore why open data ecosystems are becoming essential for enterprise AI success. In this episode, he breaks down how openness — in ...

As an Oracle performance-tuning expert, I frequently visit Oracle shops to improve system performance. Although Oracle offers many performance-tuning techniques, you can’t tune away a poor database ...

Oracle has announced the general availability of Oracle SQL Developer Release 1.2 that features new capabilities to ease the migration and consolidation of third-party databases onto Oracle Database ...

Quest Software will present the second in a two-part series of live webcasts focused on Oracle PL/SQL on Thursday, October 27, at 11 am PT/ 2 pm ET. Turbocharge Oracle PL/SQL Performance! Oracle ...

Major upgrade to the ever-evolving Oracle Database brings JavaScript support, graph optimizations, in-memory enhancements, and dramatic improvements to JSON operations and in-database machine learning ...