- 博客(4)
- 收藏
- 关注
原创 Study to use Materialized View--笔记一
Study to Use Materialized ViewHere today i am here to study Materialize View. As the information explosion, many GB,TB data is stored in Database, techniquely in tables. For these big talbe, it
2010-03-26 16:44:00 580
原创 10g New Feature--Collect function
10g New Feature--Collect function Collect Functio can use in sql query to convert multiple rows of data to a collection of data. Oracle create a SYS owned type for it. -->tested it in Wal
2010-03-23 13:48:00 666
原创 How to use partition table
What advantage does Partition table can provide? Partition table can provide data elimination. With partition, although some data is not available only if it is no the data we want to access, we ca
2010-03-18 17:47:00 689
原创 Point for Binding In-list
1. invoker right: 需要给调用者显式的权限。 (authid current_user)definer right: procedure运行使用创建者的权限。 特别对dynamic sql, 使用definer right是很危险的。 有可能调用者可以drop table. 一般使用invoker right. 2. ORA-02030: can only s
2010-03-11 15:33:00 460
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人