In a previous YugabyteDB Tip, Simulate Synonyms in YSQL, we showed how changing the search_path lets you query objects in different schemas […]
Read More
Migrating Exception Handling from Oracle to YugabyteDB
When migrating PL/SQL code from Oracle to YugabyteDB’s PostgreSQL-compatible YSQL layer, one of the trickiest differences is exception handling. Oracle has its […]
Read MoreOrphaned Indexes: Oracle vs. YugabyteDB
If you’re migrating from Oracle to YugabyteDB, you may have run across the concept of orphaned indexes. In Oracle, there are views […]
Read MoreMigrating Oracle Cursors to YugabyteDB
Oracle developers often rely on explicit cursors to loop through result sets or to parameterize queries inside PL/SQL procedures. When migrating to […]
Read MoreEmulating Oracle’s SYS_CONTEXT in YugabyteDB
If you’ve worked with Oracle, you’ve probably used SYS_CONTEXT to grab runtime environment information—things like the current user, client IP, or host […]
Read More