
Oracle 数据库
文章平均质量分 83
jinger_z
这个作者很懒,什么都没留下…
展开
-
Oracle join 用法 总结
T1 { [INNER] | { LEFT | RIGHT | FULL } [OUTER] } JOIN T2 ON boolean_expressionT1 { [INNER] | { LEFT | RIGHT | FULL } [OUTER] } JOIN T2 USING ( join column list )T1 NATURAL { [INNER] | { LEFT | RIGHT | FULL } [OUTER] } JOIN T2INNER 和 OUTER 对所有连接(join) 类型都原创 2010-10-03 23:59:00 · 939 阅读 · 0 评论 -
Oracle 常用SQL
<br />一、查看数据库的SQL<br />1、查看表空间的名称及大小<br /><br /> select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size<br /> from dba_tablespaces t, dba_data_files d<br /> where t.tablespace_name = d.tablespace_name<br /> group by t.tablespace_name原创 2010-10-03 23:51:00 · 421 阅读 · 0 评论 -
Oracle PL/SQL
<br />1, PL/SQL and SQL difference :<br /> <br /> SQL gives us complete access to our data , By complete, I mean we can get to everything...eventually.. in less than <br />ideal ways in many cases. There is no guarantee of efficiency and few actual p原创 2010-10-05 21:58:00 · 440 阅读 · 0 评论