专注Java（全栈）应用开发，求知若渴，虚心若愚，talk is cheap, show me the code.

字符型ASCIICHRchr(39) chr(10) chr(9)LOWERUPPERINITCAPCONCAT||SUBSTRLENGTHINSTRTRIMdumplpadrpadREPLACEtranslate ('ABCDEFABCXYZ','ACB','abc')ASCII('字符')返回字符的ASCII码值idle> select ASCII...

正则表达式函数 (10g引入)基本^ $ ^$. a* .*[a-z] [A-Z] [a-Z] [0-9][abc] [^abc] ^[abc] ^[^abc][a^bc]\< \>拓展() | {} + ?[:alnum:], [:alpha:], [:cntrl:], [:digit:], [:graph:],[:lower:], [:print:], [:p...

数值型函数ROUNDTRUNCMODCEILpowerROUND(列名|表达式,n)四舍五入到小数点后的n位idle> select round(458.734,0),round(458.734,1),round(458.734,-1) from dual;ROUND(458.734,0) ROUND(458.734,1) ROUND(458.734,-1)-------...

非归档状态：outline: name click me 关库状态 click me 开启状态 操作 数据完整性   inactivate shut immediate   mount 清空logs 没关系   activatecurrent shtu immediate     ...

参考资料： 搭建DGhttps://blog.youkuaiyun.com/dbdeep/article/details/78245699搭建RAC：http://blog.itpub.net/31529886/viewspace-2158128/搭建MAA：https://blog.youkuaiyun.com/lqx0405/article/details/44777...

1.安装组件：正常返回信息为：access control disabled,clients can connect from any host如果xhost +不能执行，报错：xhost ： unable to open display ""可以输入命令export DISPLAY=:0执行一下再执行xhost +就可以安装oracle了，但是如果没有安装成功 重启l...