ITeye博客

2012 年文章归档

共 10 篇文章

from string get number data using pl/sql or sql

declare @aa varchar(80),----INFO列 @bb varchar(80) set @aa ='你好12按时地方' set @bb='' while PATINDEX('%[0-9]%',@aa)<>0 /*每次循环找出一个数字*/ begin set @bb = @bb+substring(@aa,PATINDEX('%[0-9]%',@aa),1)/*把找出来的数字进行相加*/ set @aa=substring(@aa,1,PATINDEX('%[0-9]%',@aa)-1)+ substring(@aa,PATINDEX('%[0-9]%',@aa)+1,le…

2012-02-16 17:32 · oracle

SQL

1.select sal salary from emp; select sal as salary from emp; select sal as "salary" from emp; select comm "comm sal" from emp; column alias can not use where clause 2.DML select,insert,update,delete,merge DCL grant,revoke DDL create,drop,alter,rename,truncate DTL commit,rollback,savepoint 3.select …

2012-02-15 18:01 · oracle

modify ip

1.netconfig 2./etc/sysconfig/network-scripts, find ifcfg-eth0,ifcfg-eth1.... modify IPADDR 3./etc/rc.d/init.d/network ifconfig eth0 hw ether 192.168.2.252 ifconfig eth0 192.168.2.252 netmask 255.255.255. last:service network restart

2012-02-10 17:45 · oracle

MULTI dbwr or io slaves

thanks dukope of itpub. Consider Multiple Database Writer (DBWR) Processes or I/O Slaves Configuring multiple database writer processes, or using I/O slaves, is useful when the transaction rates are high or when the buffer cache size is so large that a single DBWn process cannot keep up with the lo…

2012-02-10 15:21 · oracle

FAQS

1.How can I get the largest amount of physical reads by any query? select disk_reads, sql_text from v$sqlarea where disk_reads >1000 order by disk_reads desc ; 2. V$FIXED_TABLE This view displays all dynamic performance tables, views, and derived tables in the database 3.What is the difference betw…

2012-02-09 15:59 · oracle

web

http://www.opensoftlab.com/index.php http://www.supportcenter.cn/viewthread.php?tid=55763 http://www.oracle.com/pls/db102/homepage?remark=tahiti http://www.dbapool.com/ oracle dba "oracle*dba" a b -c aORb site:oracle.com "java" oracle rac filetype:pdf inurl:jsp intitle:oracle dba "oracle dba" link:…

2012-02-09 10:26 · others

web login

http://www.baidu.com/search/url_submit.html https://accounts.google.com/ServiceLogin?service=sitemaps&passive=1209600&continue=https://www.google.com/webmasters/tools/submit-url/?hl%3Dzh-CN%26continue%3D/addurl&followup=https://www.google.com/webmasters/tools/submit-url/?hl%3Dzh-CN%26continue%3D/ad…

2012-02-09 10:07 · others

HOW TO STUDY ORACLE FROM Yong Huang

Assuming you want to study oracle database, specifically to prepare yourself as a DBA, not other products such as Apps or Developer Suite...] 1.0 Download from otn.oracle.com, or borrow CDs for, oracle server software enterprise edition. Make sure it's not any other lesser edition. Choose the OS yo…

2012-01-18 14:48 · oracle

RMAN

1.components of the rman rman server process channel rman repository recovery catalog database 2.when using rman connected to target database,default having two rman server process.(one is establishing the connection for rman to database, the other is pool rman server process ) 3.in auto allocate c…

2012-01-14 17:07 · oracle

INSTANCE and CRASH RECOVERY

1.type of checkpoint full checkpoint alter system checkpoint incrimental checkpoint(logfile switch) alter system switch logfile. partial checkpoint alter tablespace backup/online/offline 2.phases of instance recovery 1.chek asydatafiles. 2.cache rocovery(roll forward withredo),open database. 3.tran…

2012-01-12 10:12 · oracle