Oracle SQL基础
jsjzzh
这个作者很懒,什么都没留下…
展开
-
Introduction to Oracle9i:SQL 学习笔记1
Introduction to Oracle9i:SQL 学习笔记原创 2010-12-19 21:54:00 · 344 阅读 · 0 评论 -
SELECT各关键字解析执行顺序
例select ID,OyaID,Level, sys_connect_by_path(to_char(ID),',')as path from edaKiri Join dual on ID notin(3,22) start with OyaID isnull connect by prior ID = OyaID --亲子条件orderby ID;1. from句 2. where句 (结合条件) 3. start with句 4. connect by句 5.转载 2011-02-10 14:12:00 · 510 阅读 · 0 评论