WEN_Windy的博客

1.Oracle中字符拼接符号为||例：select'a'||'b'||'c'fromdual; --dual为临时表2.Oracle不等于号是<>与mysql中的!=是一样的例：selectcasewhen1!=2then'true'else'false'endasA,casewhen1<>2then'true'else'false'endasBfromdual3.nvl函数（nvl(a,b)如果a为空则为b,...