ITPub博客

float datatype in Oracle database 2005 年 08 月 25日, 星期四作了一个测试，就像我们以前一直提醒的一样。在使用非 number datatype 的 数字类型一定要注意。create table t_float (f float(2),n number(2))...

MM-DD-RRRR / MM-DD-YYYY 的区别 （Date format）2005 年 08 月 15日先各位执行一下下面SQL. 结果会如何呢？select to_date('05/01/02','YYYY-MM-DD') YYYY ,to_date ('05/01/02','RRRR-MM-DD') RRRR from dual...

Database Link 创建注意的两点2005 年 08 月 10日, 星期三Database Link 创建注意的两点： 一般创建(Database Link Name 和 Service Name 一致) A: 先在 Server 端的tnsname.ora 中增加要访问的　database的连...

2005 年 06 月 01日, 星期三<!-- Oracle backgroud ProcessSystem Monitor Process Name: SMON Max Processes: 1 This process is responsible for instance recovery, if necessary, at instance startup....

Optimizer 的选择 【现在已经不选择了，除非特殊需求10g 以后默认都已经是Cost 】1.2.4 Which Optimizer to Use? If you are currently using the rule-based optimizer, I strongly recommend that you transfer...

Oracle Database Link Problemscle 8 数据链路在程式中不能支持：     ODBC        数据不可提交，无错误，偶尔会有错误。    Microsoft OLE DB&nb...

Oracle Optimizer -RBO (理解Rule-based 优化器)/*理解Rule-based 优化器       RBO 优先使用预定义方法去计算使用的某条路径访问数据库资料.     RDBMS 使用下列条...

oracle ora-00997 problemsOracle8i,9i 中对Long 操作有一个限制.就是:所有的select,Update,lock tables 的所有Long columns 必须在同一个Database中. 而你的SQL,正好选取了两个long columns 分别在两个dat...

Database Triggers and event attributes--Event AttributesWith the introduction of the 20 new database triggers, came the creation of attribute events or variables that are set when a certain database ...

Database Triggers and event attributes--Database System EventsThere are six database system event triggers. The six database system event triggers are outlined below, along with a description and the...

Database Triggers and event attributes--DDL/Client EventsDDL/Client Events There are 14 DDL/client event triggers and these can be created at the database level and will execute for all schemas, or ...

Database Triggers and event attributes--IntroductionIntroduction Creation of Database Triggers A database trigger is created and dropped with the following commands:     CREA...

在Oracle10gR2 之后ASM 文件可以使用FTP来进行访问，但还是要满足两个条件   1：安装XML DB   2：使用DBCA 默认创建数据库 默认情况下FTP 功能是不打开的，你可以使用Oracle 提...

  My Oracle Support is currently unavailable due to scheduled maintenance.My Oracle Support will be offline twice for maintenance on Friday, March 5 for approximately 3 hours, beginning ...

 GPFS is IBM’s high-performance parallel, scalable file system for IBM UNIX clusters capable of supporting multi-terabytes of storage within a single file system. GPFS is a shared-disk file sy...

􀂃 These products are certified for AIX 5.3 and 6.1 on all Power Systems servers supported by those versions of AIX.􀂃 64-bit hardware is required for a 64-bit application such as Orac...

【IT168 资讯】　　为中国UNIX服务器市场的三大主要厂商，IBM、惠普与SUN在该领域的角力从未停歇过。然而现在看来，三方一度曾经出现的胶着状态似已成为历史，今天，IBM的Power正在成为UNIX市场的领跑者，无论是惠...