ニュース

note

Oracle VIEW 逆引き早見表（短縮版）— 作成・確認・更新可否を ...

最短で“いま必要な手順”に辿りつくための、スマホ最適な逆引きです。 実務では「ビュー作った？」「更新できないのはなぜ？」のような“その場で答えたい問い”が多いですよね。 本稿は、一言のAnswer → 最小SQL → 注意点だけを抜き出し、詳細・実機 ...
Houston Chronicle

How to Create a CLOB in Oracle

Oracle's namesake database management system has a data type called a CLOB, or Character Large OBject. Though the standard character data type, called CHAR, has a size limit of 2,000 characters, you ...
Simon Fraser University

CREATE VIEW Statement

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...