Evaluates an expression after a specified number of milliseconds has elapsed.
(ÔÚÖ¸¶¨Ê±¼ä¹ýºóÖ´ÐÐÖ¸¶¨µÄ±í´ïʽ)
Syntax:
iTimerID = window.setTimeout(vCode, iMilliSeconds [, sLanguage])
Parameters
vCode
Required. Variant that specifies the function pointer or string that indicates the code to be executed when the specified interval has elapsed.
iMilliSeconds
Required. Integer that specifies the number of milliseconds.
sLanguage
Optional. String that specifies one of the following values:
JScript
Language is JScript.
VBScript
Language is VBScript.
JavaScript
Language is JavaScript.
Return Value
Integer. Returns an identifier that cancels the evaluation with the clearTimeout method.
==============================================================
ÒÔÉÏÄÚÈÝÕª×Ôij±¾JScript½Ì³Ì(CHM¸ñʽ,³ö´¦²»Ïê,¸úÔ×÷Õß˵ÉùSorry)
ÒÔÏÂÄÚÈÝû³ÈκÎÈ˵Ä,Èç¹ûÓÐÀ×ͬ,¹À¼Æ²»ÊÇÄã³Å¼µÄ¾ÍÊÇÇɺÏ,ºÙºÙ.
-------------------------------------------------------------------
setTimeout( alert("3 ......
Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore: Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications. Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ). The Trace Analyzer utility is available via download on the Oracle Metalink web site.
How Oracle trace analyzer Works
Trace Analyzer requires that a one-time configuration be performed. During this configuration, many objects are installed in the database to serve as a tracing repository. Once downloaded from Metalink and installed, a SQL script can be executed passing in the name of the trace file.
Executing Oracle Trace Analyzer
First, tracing needs enabled at the appropriate level. For example, to provide maximum trace data, a Level 12 trace can be started for the current session:
SQL> ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';
After the session executes for enoug ......
Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore: Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications. Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ). The Trace Analyzer utility is available via download on the Oracle Metalink web site.
How Oracle trace analyzer Works
Trace Analyzer requires that a one-time configuration be performed. During this configuration, many objects are installed in the database to serve as a tracing repository. Once downloaded from Metalink and installed, a SQL script can be executed passing in the name of the trace file.
Executing Oracle Trace Analyzer
First, tracing needs enabled at the appropriate level. For example, to provide maximum trace data, a Level 12 trace can be started for the current session:
SQL> ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';
After the session executes for enoug ......
Most of admins neglect setting password on TNSlsnr Clients for Oracle databases. Oracle ensures that you can either connect to TNSlsnr on a localhost or through mapping to a remote Oracle database using .ora files.
This is not the case anymore Based on Jwa perl client.
This client is a FULL client, with Packet crafting reassembled.
Supports all the commands as the version that is shipped with Oracle.
Allow you to totally control an unprotected Oracle Database Server remotelly , without having to map or install Oracle.
Download Here
Commands Supported
ping , version , service , status change_password, help, reload, save_config, set connect_timout set display_mode, set log_directory , set log_file , set log_status , show , spawn stop
this version works on Oracle9i.
On Oracle 10g only "version" command is working.
This is feedback i got from Pete Finnigan Oracle Security
The 10g listener is by default protected by local authentication rather than by a password like in the ......
Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇø·Ö²»Í¬Êý¾Ý¿âµÄ²ÎÊý¡£
Ò»¡¢Ê²Ã´ÊÇÊý¾Ý¿âÃû(db_name)?
Êý¾Ý¿âÃûÊÇÓÃÓÚÇø·ÖÊý¾ÝµÄÄÚ²¿±êʶ£¬ÊÇÒÔ¶þ½øÖÆ·½Ê½´æ´¢ÓÚÊý¾Ý¿â¿ØÖÆÎļþÖеIJÎÊý£¬ÔÚÊý¾Ý°²×°»ò´´½¨Ö®ºó½«²»µÃÐ޸ġ£Êý¾Ý¿â°²×°Íê³Éºó£¬¸Ã²ÎÊý±»Ð´ÈëÊý¾Ý¿â²ÎÊýÎļþpfileÖУ¬¸ñʽÈçÏ£º
.........
db_name="orcl" #(²»ÔÊÐíÐÞ¸Ä)
db_domain=dbcenter.toys.com
instance_name=orcl
service_names=orcl.dbcenter.toys.com
control_file=(...............
.........
ÔÚÿһ¸öÔËÐеÄORACLE8iÊý¾Ý¿âÖж¼ÓÐÒ»¸öÊý¾Ý¿âÃû(db_name),Èç¹ûÒ»¸ö·þÎñÆ÷³ÌÐòÖд´½¨ÁËÁ½¸öÊý¾Ý¿â£¬ÔòÓÐÁ½¸öÊý¾Ý¿âÃû¡£Æä¿ØÖƲÎÊý¾Ý·ÖÊôÔÚ²»Í¬µÄpfileÖпØÖÆ×ÅÏà¹ØµÄÊý¾Ý¿â¡£
¶þ¡¢Ê²Ã´ÊÇÊý¾Ý¿âʵÀýÃû(instance_name)
Êý¾Ý¿âʵÀýÃûÔòÓÃÓںͲÙ×÷ϵͳ֮¼äµÄÁªÏµ£¬ÓÃÓÚ¶ÔÍⲿÁ¬½ÓʱʹÓá£ÔÚ²Ù×÷ϵͳÖÐҪȡµÃÓëÊý¾Ý¿âÖ®¼ä ......
ÏÂÔØ·½·¨£ºÔÚÏÂÃæµÄÁ¬½ÓÉϵã»÷ÓÒ¼ü£¬Ñ¡ÔñʹÓÃѸÀ×ÏÂÔØ¡£Ê¹ÓñðµÄÏÂÔØ¹¤¾ßÎÞ·¨ÏÂÔØ¡£
oracle 10.2.0.4 ²¹¶¡ÏÂÔØ£¨ÊÊÓÃÓÚËùÓвÙ×÷ϵͳ£©:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip
......
×î½ü´ÓExcelÖе½ÁËһЩÊý¾Ý£¬½á¹ûÒ»¸öÁеÄÊý¾ÝÊÇÒÔ¶ººÅ·Ö¸ôµÄ×Ö·û´®£¬Ïë°ÑËü²ð·Ö¿ªÕÒµ½ÁËϱߵķ½·¨£¬Ìù³öÀ´·ÖÏíһϣº
CREATE OR REPLACE PROCEDURE sptstr (srcstr varchar2) as
stmp varchar2(2000);
begin
select srcstr into stmp from dual;
while nvl(length(stmp),0) > 1
loop
insert into tabtest(col) select substr(stmp,1,instr(stmp,',')-1 ) from dual;
select substr(stmp,instr(stmp,',')+1) into stmp from dual;
end loop ;
commit;
end sptstr;
Ï ......