ITPub博客

可以在下列场合中使用：1. VALUES clause of INSERT statements2. The SELECT list of a SELECT statement3. The SET clause of an UPDATE statement而不能在下列场合使用：■ A subquery■ A view query or materialized view query■ A SELECT statement with the DISTINCT operator■ A SELECT statement with a GROUP BY or ORDER BY clause■ A SELECT statement that is combined with another SELECT statement with the UNION, INTERSECT, or MINUS set operator■ The WHERE clause of a SELECT statement■ DEFAULT value of a

各位准备向灾区奉献您的爱心的朋友,请参阅http://news.xinhuanet.com/politics/2008-05/13/content_8158260.htm注意提防诈骗短信.[@more@]

请参阅http://www.yeeyan.com/articles/view/zww/7740[@more@]

http://www.orafaq.com/wiki/DBMS_SCHEDULERDBMS SCHEDULER is a more sophisticated job scheduler introduced in Oracle 10g. The older job scheduler, DBMS_JOB, is still available.Contents * 1 Create a job * 2 Remove a job * 3 Run a job now * 4 Change job attributes * 5 Monitoring jobsCreate a jobBEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'my_java_job', job_type => 'EXECUTABLE', job_action => '/usr/bin/java myClass', repeat_interv

启动电脑,打开firefox,输入g.cn,却发现不能正常打开网页,昨天走的时候还是很正常啊,咋回事呢？借同事的电脑google了一下,网页http://support.microsoft.com/kb/316414给出了解决办法。卸载zonealarm , 将windows自带防火墙关闭,重启电脑 . ok[@more@]

Renaming permanent and temporary tablespaces is now allowed in Oracle 10g (except for SYSTEM and SYSAUX) using the following command. ALTER TABLESPACE ts_current_name RENAME TO ts_new_name;The tablespace and all it's datafiles must be online and the database must have a COMPATIBLE setting of 10.0.0 or greater.If the tablespace is read-only the datafile headers are not altered to reflect the name change and a message is written to the alert log to notify you of this fact. The impact on recover

Link From : http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=4688REM RMAN Progressalter session set nls_date_format='dd/mm/yy hh24:mi:ss'/select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,sysdate + TIME_REMAINING/3600/24 end_atfrom v$session_longopswhere totalwork > sofarAND opname NOT LIKE '%aggregate%'AND opname like 'RMAN%'/REM RMAN wiatsset lines 120column sid format 9999column spid format 99999column client_info format a25column event format a30c

use parameter exclude=statistics没有实验 暂且记录[@more@]

http://wiki.oracle.com/[@more@]

The records_per_block_clause lets you specify whether Oracle Database restricts the number of records that can be stored in a block. This clause ensures that any bitmap indexes subsequently created on the table will be as compressed as possible.Restrictions on Records in a Block ■ You cannot specify either MINIMIZE or NOMINIMIZE if a bitmap index has already been defined on table. You must first drop the bitmap index.■ You cannot specify this clause for an index-organized table or a nested tab

http://www.orafaq.com/cgi-bin/sqlformat/pp/utilities/sqlformatter.tpl[@more@]

orafaqA deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. The session that is rolled back will observe Oracle error: ORA-00060: deadlock detected while waiting for resource. Oracle will also write ou

第一阶段可称之为“生产力平台”，其中Office和Lotus等办公软件是其中典型代表；第二阶段可称之为“运营平台”，其中包括ERP、CRM等提高企业管理和生产效率的平台；第三阶段可叫做“智能平台”，即BI系统平台。[@more@]

1. 老子云：知人者智，自知者明，胜人者勇，自胜者强，强行者有志 。2. 花荣在《操盘手》中讲散户炒股时说："炒"股"炒"股，就是钱越炒越"少"，心里炒的越来越上"火"，合起来就是一 "炒"字。——其实让女人来炒，岂不妙哉！3. 一个人智力有问题，是次品；一个人的灵魂有问题，就是危险品。经营人心就是经营事业。 —— 牛根生4. 管理是严肃的爱。 —— 牛根生5. 找一个像EXCEL一样的男朋友——想隐藏就隐藏，想筛选就筛选，想删除就删除，一个不高兴，嘿，我还就不保存了。6.

V$SQL_BIND_CAPTURE displays information on bind variables used by SQL cursors. Each row in the view contains information for one bind variable defined in a cursor. This includes:■ Reference to the cursor defining the bind variable(hash_value, address) for the parent cursor and (hash_value, child_address) for the child cursor.■ Bind metadataName, position, datatype, character set ID, precision, scale, and maximum length of the bind variable.■ Bind dataOne of the bind values used for the bind v

If an error occurs while reading the server parameter file (during startup or an export operation), or while writing the server parameter file during its creation, the operation terminates with an error reported to the user.If an error occurs while reading or writing the server parameter file during a parameter update, the error is reported in the alert log and all subsequent parameter updates to the server parameter file are ignored. At this point, you can take one of the following actions:■ S

因为是通过代理上网，在 "工具->选项"，在[选项] 弹出框中 选择"高级" ，选择[网络]，点击[设置]，将[为所有协议使用相同代理]复选框，问题即解决。[@more@]

You can use the CREATE PFILE statement to export a server parameter file to a text initialization parameter file. Doing so might be necessary for several reasons:■ For diagnostic purposes, listing all of the parameter values currently used by an instance. This is analogous to the SQL*Plus SHOW PARAMETERS command or selecting from the V$PARAMETER or V$PARAMETER2 views.■ To modify the server parameter file by first exporting it, editing the resulting text file, and then re-creating it using the

SCOPE = SPFILE The change is applied in the server parameter file only. The effect is as follows:■ For dynamic parameters, the change is effective at the next startup and is persistent. ■ For static parameters, the behavior is the same as for dynamic parameters. This is the only SCOPE specification allowed for static parameters.SCOPE = MEMORY The change is applied in memory only. The effect is as follows:■ For dynamic parameters, the effect is immediate, but it is not persistent because the

The SPFILE initialization parameter contains the name of the current server parameter file. When the default server parameter file is used by the server (that is, you issue a STARTUP command and do not specify a PFILE), the value of SPFILE is internally set by the server. The SQL*Plus command SHOW PARAMETERS SPFILE (or any other method of querying the value of a parameter) displays the name of the server parameter file that is currently in use.[@more@]