Íæ×ªOracle£¨4£©
//ʹÓÃ×Ô¶¨Ò庯Êý¶¨ÒåÈÕÆÚ¸ñʽ
to_date('1982-11-11','yyyy-mm-dd')
to_date('1982/11/11','yyyy/mm/dd')
//Ï£ÍûÔ±¹¤scottµÄ¸Ú룬¹¤×Ê£¬²¹ÖúÓësmithÔ±¹¤Ò»Ñù
update emp set (job,sal,comm)=(select job,sal,comm from emp where ename='SMITH') where ename='SCOTT';
||------- javaʹÓÃoracle -------||
//jdbc-odbc
//1.¼ÓÔØÇý¶¯ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//2.µÃµ½Á¬½Ó conn = DriverManager.getConnection("jdbc:odbc:oracle_source","scott","tiger");
//jdbcÖ±Á¬
//1.¼ÓÔØÇý¶¯ Class.forName("oracle.jdbc.driver.OracleDriver");
//2.µÃµ½Á¬½Ó conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","tiger");
||------- oracleµÄÊÂÎï´¦Àí -------||
dmlÓï¾ä //Ôöɾ¸Ä
µ±Ö´ÐÐÊÂÎñ²Ù×÷ʱ£¨dmlÓï¾ä£©£¬oracle»áÔÚ±»×÷ÓõıíÉϼÓËø£¬·ÀÖ¹ÆäËüÓû§¸Ä±íµÄ½á¹¹£¬ÕâÀï¶ÔÎÒÃÇÓû§À´½²ÊǷdz£ÖØÒªµÄ
//»Ø¹öÃüÁî
savepoint a; //´æ´¢»Ø¹öµã
rollback to a; //»Ø¹öµ½´æ´¢µã
rollback //È¡ÏûÈ«²¿ÊÂÎï
commit; //µ±Ö´ÐÐÁËcommit¾Í²»ÄܻعöÁË
exit; //Í˳öÔò×Ô¶¯Ìá½»ÊÂÎñ
//javaʹÓÃÊÂÎñ
conn.setAutoCommit(false); //ÉèÖò»×Ô¶¯Ìá½»
conn.commit(); //ÊÖ¶¯Ìá½»
conn.rollback(); //Èç¹û³öÏÖÒì³£»Ø¹öÊÂÎï
//Ö»¶ÁÊÂÎֻÔÊÐí²éѯµÄ²Ù×÷£¬¶ø²»ÔÊÐíÆäËûdmlµÄ²Ù×÷
set transaction read only;
||------- oracleµÄsqlº¯Êý -------||
//
//×Ö·ûº¯Êý
//
lower(char) //Сд
upper(char) //´óд
length(char) //³¤¶È
substr(char,m,n) //È¡×Ö·û´®µÄ×Ó´®
replace(char1,search_string,replace_string) //Ìæ»»º¯Êý
instr(char1,char2,[,n[,m]]) //È¡×Ó´®ÔÚ×Ö·û´®µÄλÖÃ
//½«ËùÓÐÔ±¹¤µÄÃû×Ö°´Ð¡Ð´µÄ·½Ê½ÏÔʾ
select empno,lower(ename) from emp;
//½«ËùÓÐÔ±¹¤µÄÃû×Ö°´´óдµÄ·½Ê½ÏÔʾ
select empno,upper(ename) from emp;
//ÏÔʾÕýºÃΪ5¸ö×Ö·ûµÄÔ±¹¤ÐÕÃû
select * from emp where length(ename) = 5;
//ÏÔʾËùÓÐÔ±¹¤Ãû×Öǰ3¸ö×Ö·û
select substr(ename,1,3) from emp;
//ÒÔÊ××Öĸ´óдµÄ·½Ê½ÏÔʾËùÓÐÔ±¹¤ÐÕÃû
select (upper(sub
Ïà¹ØÎĵµ£º
1¡¢oracle½ø³ÌÌåϵ½á¹¹
2¡¢oracleÄÚÖöÔÏó
3¡¢¹ØÓÚoracleÔÚÏßÈÕÖ¾¡¢¹éµµÈÕÖ¾¡¢Êý¾Ý¿â»Ö¸´¡¢rman
4¡¢Ñ§Ï°goldengateµÄÅäÖÃ
5¡¢¹ØÓÚoracleµÄ¸÷°æ±¾Éý¼¶·½·¨£»
½«oracle10g Éý¼¶ÖÁ10.2.0.4
http://www.cnblogs.com/zhou__zhou/archive/2009/10/07/oracle_patch.html ......
¹«Ë¾Ê¹ÓÃlinux¿ª·¢»ú½øÐгÌÐò¿ª·¢Ê±£¬ÓÉÓÚ¿ª·¢ÓÃOracleÊý¾Ý¿âÊÇÓÉÈÕ·½Ìṩ£¬ËùÒÔ¾³£Ê¹ÓÃsqlplusÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÉϽøÐпª·¢,ÀýÈ磺
sqlplus username/password@servicename
ÓÚÊÇÏ룬ÓÃÎÒµÄÁ½Ì¨µçÄÔË«»ú»¥ÁªÊÔÒ»ÊÔ£¬Ò²Íæ¸ö“Ô¶³ÌÁ¬½Ó”¡£ÊµÑéÈçÏ£º
Ê×ÏÈÔÚÎÒµĄ̈ʽ»úÉϰ²×°ÁËOracle9iµÄÊý¾Ý¿â¹ÜÀíϵͳ£¬ ......
ÓÉÓÚ¹«Ë¾ÒµÎñÔö³¤½Ï¿ì£¬Êý¾Ý¿âoracleѹÁ¦Ô½À´Ô½´ó£¬¹«Ë¾¿¼ÂÇÔÚÓ¦Ó÷þÎñÆ÷ Websphere ºÍ Êý¾Ý¿âoracleÖ®¼äÔö¼Ó timestenÊý¾Ý¿âÀ´ÊµÏÖÊý¾ÝµÄ¶Áд·ÖÀ룬ÁíÍâÓÉÓÚtimestenÊÇÄÚ´æÊý¾Ý¿â£¬ËùÒÔ²éѯËÙ¶ÈÉÏÒªÓÅÓÚ oracle Êý¾Ý¿â£¬Á½¸öÊý¾Ý¿âËäÈ»¶¼ÊÇoracle¹«Ë¾µÄ²úÆ·£¬µ«ÊÇÔںܶàsqlµÄд·¨ÉÏÊDz»ÏàͬµÄ£¬Ï ......
¾Ñ飺
alter system set log_archive_dest=’D:\oracle\archivelog’ scope=spfile;
alter system set log_archive_start=true scope=spfile;
Ö®ºó£¬
create pfile from spfile
¿ÉÑéÖ¤¼ÓÉÏû
Ò»¡¢²é¿´Êý¾Ý¿âÔËÐÐģʽ
¿ÉÒÔÓ󬼶Óû§£¨INTERNAL£©ÔÚSQLPLUSÖÐʹÓÃÃüÁîARCHIVE LOG LIST²é¿´
......
н¨Îļþϵͳ
crfs -v jfs -g rootvg -m /arch -a \ size=32768 -a frag=512 -a nbpi=8192 Ò²¿ÉÒÔ smit¡£
¿ªÆô¹éµµÄ£Ê½
$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 10 13:38 ......