aws.amazon

Amazon Bedrock 기반 멀티 에이전트 GAMMA로 Oracle-to-PostgreSQL 마이그레이션 가속화하기

클라우드 전환을 가속화하는 조직들은 공통된 병목에 직면합니다. 바로 핵심 비즈니스를 지탱하는 레거시 시스템의 현대화(Modernization)입니다. 기업이 Oracle에서 Amazon Aurora PostgreSQL-Compatible Edition ...
snowflake

Migrating Oracle PL/SQL Stored Procedures with Output Arguments to Snowflake

A new chapter has begun in the Snowflake ecosystem for data engineers and developers. On July 2, 2025, Snowflake's 9.18 release introduced a long-awaited feature: support for OUT parameters in stored ...
Hacker

How to Create Purchase Order Lines in Oracle R12 (with PL/SQL Examples)

Vinish Kapoor is an Oracle ACE Pro, software developer, and founder of Vinish.dev, known for his expertise in Oracle. Vinish Kapoor is an Oracle ACE Pro, software developer, and founder of Vinish.dev, ...
gist.github

Oracle PL/SQL 19.0 Guide

Clone this repository at <script src="https://gist.github.com/jgarza9788/60731a979f479cc26b8e0887c7ecafbc.js"></script> Save jgarza9788 ...
habr

Введение в PL/SQL

Для меня PL/SQL есть логичное продолжение изучения SQL, но по нему много и статей, и курсов, причем даже на русском языке. С другой стороны, PL/SQL ...
GitHub

create table+ procedures.sql

-- Procedure to insert data into the EmployeeTitle table CREATE OR REPLACE PROCEDURE InsertEmployeeTitle ( p_TitleID INT, p_Title VARCHAR2 INSERT INTO EmployeeTitle (TitleID, Title) -- Procedure to ...
blog.csdn

DBMS_UTILITY.comma_to_table & table_to_comma

1、Oracle 集合是相同类型元素的组合，在集合中，使用唯一的下标来标识其中的每个元素，与 Java 的 List 很像。 索引表：不需要初始化或者extend，且无个数限制，迄今为止最高效的集合类型 ...
blog.csdn

了解PL/SQL看这一篇够够了~

Oracle的图形化工具PL/SQL介绍及使用 PL/SQL是oracle对sql语言的过程化扩展在SQL语言中添加了过程处理语句（如分支，循环），使SQL ...
databricks.com

How To Migrate Your Oracle PL/SQL Code to Databricks Lakehouse Platform

In this blog post, we'll focus on converting PL/SQL proprietary code to an open standard python code and take advantage of PySpark for ETL workloads and Databricks SQL's data analytics workload power.