Oracle developers often rely on explicit cursors to loop through result sets or to parameterize queries inside PL/SQL procedures. When migrating to […]
Read More
Emulating 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 MoreOracle-Style Partition Views in YugabyteDB: USER_TAB_PARTITIONS and ALL_TAB_PARTITIONS
If you’re migrating from Oracle and miss USER_TAB_PARTITIONS and ALL_TAB_PARTITIONS, you can recreate them in YugabyteDB with two simple views over the […]
Read MoreMigrating Oracle Range Partitions to YugabyteDB (YSQL)
When moving Oracle partitions that omit a lower or upper bound, translate them to Postgres/YSQL using MINVALUE and MAXVALUE. Also remember that […]
Read More