DB/Oracle/PLSQL/ʬ

ܼ

ˤäʬ롣 IF ʸ CASE ʸ


IF ʸ

IF ʸˤʬۤθȰʤΤۤɤΤΤǤʤʤȤݡ

  • IF ʸε

CASE ʸ

CASE ʸˤʬۤθȰʤΤۤɤΤΤǤʤʤȤݡ

CASE CASE ʸ餷ͤ˻ȤΤ CASE ʬ˻ȤΤ CASE ʸ

CASE

ͤȤ˻Ȥ

  • CASE

CASE ʸ

IF ʸƱȤ CASE ʸǤ⤫롣֤ IF ʸΤŪ

  • CASE ʸ
    declare
        hoge number := 1;
    begin
        case hoge
            when 1 then
                ...
            when 2 then
                ...
            else
                ...
        end case;
    end;
    

NULL ͤΰ

NULL ͤȤñӡʤꡢʤꡢʤɡˤϾ˷̤ NULL ˤʤ롣TRUE Ǥ FALSE Ǥʤ NULL

黻ξϤäʣ

NULL ˤʤä硢ξξμ¹ʸϼ¹Ԥʤ

NULL ñ

羮ӡӤʤɤñӤξ硢̤Ͼ NULL ˤʤ롣IF ʸ CASE ʸȽ̤ NULL ä硢ʬϼ¹ԤʤξǤϰ FALSE Ʊ

  • NULL

NULL 黻

TRUE FALSE NULL Ȥ AND Ȥ OR DZ黻ɤʤΤȤá

  • AND 黻
    ANDTFN
    TTFN
    FFFF
    NNFN
  • OR 黻
    ORTFN
    TTTT
    FTFN
    NTNN
  • NOT 黻
    NOT
    TF
    FT
    NN

Ūʹͤϰʲ̤ꡣ

  • AND Ǥ FALSE ͥ衣OR Ǥ TRUE ͥ
  • AND ξ TRUE ΤȤΤ TRUE
  • OR ξ FALSE ΤȤΤ FALSE

Last-modified: 2011-11-08 () 10:39:12