More than 5 years have passed since last update.

一番簡単なplsql

plsql

Last updated at 2019-07-01Posted at 2019-07-01


DECLARE
    tantou_count NUMBER(7);
BEGIN
    select count(*) into tantou_count from "Ｋ受担当Ｄ";
    DBMS_OUTPUT.PUT_LINE(tantou_count);
EXCEPTION
    WHEN too_many_rows THEN null;
END;
/

日本語のテーブル名は意外とわかりやすいけど、文字化けで苦しむので、
やっぱりなくしたほうがいい。

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up