rdbms-prgms

A collection of 12 RDBMS programs covering SQL DDL, DML, PL/SQL cursors, triggers, functions, stored procedures, and database design. Perfect for learning and reference.

Installation

npm install rdbms-prgms

Usage

Get the file path

const rdbms = require('rdbms-prgms');

// Get the absolute path to the programs file
const filePath = rdbms.getProgramsFilePath();
console.log(filePath);

Read the content

const rdbms = require('rdbms-prgms');

// Read the full content of all programs
const content = rdbms.getProgramsContent();
console.log(content);

Copy to your project

const rdbms = require('rdbms-prgms');

// Copy the programs file to your project directory
const copiedPath = rdbms.copyTo('./my-programs');
console.log('Copied to:', copiedPath);

// Copy with a custom filename
rdbms.copyTo('./my-programs', 'rdbms-examples.sql');

List all programs

const rdbms = require('rdbms-prgms');

// Get the list of all included programs
rdbms.programs.forEach(p => {
  console.log(`${p.id}: ${p.name} (line ${p.line})`);
});

Included Programs

| # | ID | Program | |---|------|---------| | 1 | prgm1 | DDL Commands (CREATE, ALTER, TRUNCATE, DROP) | | 2 | prgm2 | DML Commands (INSERT, UPDATE, DELETE, SELECT) | | 3 | prgm3 | Electricity Bill Calculation (PL/SQL Cursor) | | 4 | prgm4 | PL/SQL Program 4 | | 5 | prgm5 | PL/SQL Program 5 | | 6 | prgm6 | PL/SQL Program 6 | | 7 | prgm7 | PL/SQL Program 7 | | 8 | prgm8 | PL/SQL Program 8 | | 9 | prgm9 | PL/SQL Program 9 | | 10 | prgm10 | PL/SQL Program 10 | | 11 | prgm11 | PL/SQL Program 11 | | 12 | prgm12 | PL/SQL Program 12 |

License

MIT