GitHub

MariemeZ/PL-SQL-Project

This project is a comprehensive implementation of various PL-SQL functionalities. It involves creating and managing a database, developing an interactive interface, and writing PL-SQL triggers, ...
GitHub

plsql code fails with variable referencing a table column type in Oracle nested procedure

I am getting an error declaring a variable referencing a table column type in an Oracle nested procedure. I'm using dbeaver Community 23.0.3.202304240616. Here is the ...
TechRepublic

Avoiding TOO_MANY_ROWS errors in PL/SQL

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...
note

SQL Server Management Studio（SSMS）で役立つ基本クエリ集

① SQL Serverで現在のデータベースに存在するテーブル一覧を取得するクエリ -- データベース内に存在するテーブル一覧を取得 SELECT TABLE_SCHEMA, -- スキーマ名（例：dbo） TABLE_NAME, -- テーブル名 TABLE_TYPE -- テーブル種別（'BASE TABLE' または 'VIEW'） FROM INFORMATION_SCHEMA ...