Skip to content

Instantly share code, notes, and snippets.

@gourab5139014
gourab5139014 / create_hr_schema.sql
Last active November 14, 2025 00:42
Script to create Oracle XE's HR schema in Postgres
-- Best used for learning purposes. Original developer also has an ER diagram available at https://tinyurl.com/oracle-hr-schema-postgres
--create tables
BEGIN;
CREATE TABLE regions
( region_id SERIAL primary key,
region_name VARCHAR(25)
);
CREATE TABLE countries