Beyond Keyword Search Traditional database search matches exact keywords. When a user searches for “laptop” they will...
martin
Powerful Pattern Matching in SQL Oracle’s regular expression functions, available since 10g, provide POSIX-compliant pattern matching directly...
When You Need Dynamic SQL Most PL/SQL uses static SQL where the statement is known at compile...
The Long Migration Reality Migrating from Oracle EBS to Oracle Cloud ERP is a multi-year journey for...
Beyond LIKE and INSTR Most APEX applications implement search using WHERE column LIKE '%search_term%'. This works for...
Undo Your Mistakes Without a DBA Oracle’s Flashback Technology is a family of features that let developers...
SQL’s Most Underused Power Feature Analytic functions (also called window functions) let you perform calculations across a...
The Challenge Cascading LOVs (where the values in one select list depend on the selection in another)...
Event-Driven Integration With ERP Cloud Rather than polling ERP Cloud APIs to detect changes, you can subscribe...
JSON Is a First Class Citizen in Oracle Since Oracle 12c Release 1, JSON has been natively...