GitHub

Oracle-Scripts-and-Notes /Notes

Oracle database prior to 8.1.6 only had DECODE function. CASE was introduced in Oracle 8.1.6 as a standard, more meaningful and more powerful function. Everything DECODE can do, CASE can. There is a ...
note

【PL/SQL全部入り！】基本からカーソル・BULKまで一気に理解する入門書

この記事では、「SQLはある程度わかるけど、プログラミングは初めて」という人に向けて、PL/SQLを基礎から実践まで分かり ...
LinkedIn

Deepak Timsina’s Post

DECODE in #SQL Decode compares expr to each search value one by one. If expr is equal to a search, then Oracle Database returns the corresponding result. If no match is found, then Oracle returns ...
LinkedIn

What does a pl/sql developer do?

Pl/sql stands for Procedural Language/Structured Query Language. It is a programming language that extends the capabilities of SQL, the standard language for querying and manipulating data in ...