DataBase
leoric82
这个作者很懒,什么都没留下…
展开
-
How to generate E R diagram using Oracle SQL developer
File → Data Modeler → Import → Data Dictionary → select DB connection (add if none) → Next → last few steps intuitive.原创 2014-02-20 14:21:38 · 101 阅读 · 0 评论 -
plsql 常用函数
[code="java"]--(1)处理字符的函数--|| CONCAT 并置运算符--格式:CONCAT(STRING1, STRING2)SELECT CONCAT('test','oracle') FROM dual;SELECT 'test'||'oracle' FROM dual;--ASCII 返回字符的ascii码SELECT ASCII('A...原创 2014-04-29 21:58:33 · 121 阅读 · 0 评论