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