Íæת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
Ïà¹ØÎĵµ£º
Ò»£¬Ó²¼þÅäÖÃ×îµÍÒªÇó£º
32루X86£©£º
¸öÈËÈÏΪÖÁÉÙ1GÄڴ棨linux ÉÏ512M ¿ÉÒÔ£¬µ«Ì«¹ýÓÚÃãÇ¿ÁË£¬ÄÇÑùÈÝÒ×ËÀ»ú»ò¿¨×¡²»¶¯£¬»áÈÃÈË×¥¿ñµÄ;
windows 512M µÄ¿Ï¶¨²»ÐУ©
10GµÄ¿ÉÓô ......
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 ......
ÆäʵÕâ¸öºÜ¼òµ¥¾Í°²×°Èý¸ö°ü¾Í¿ÉÒÔÁË£¬·Ö±ðÊÇ£º
IO-Tty-1.07.tar.gz£¬Term-ReadLine-Gnu-1.16.tar.gz£¬ uniread-1.01.tar.gz¡£
ÕâÈý¸ö°üÔÚÎҵĿռäÀﶼÓÐ http://fwx515354.download.csdn.net/
½âѹ
tar -zxvf IO-Tty-1.07.tar.gz
tar -zxvf Term- ......
¾Ñ飺
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²é¿´
......
SELECT sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //ÕýÈ·Ö´ÐÐ
SELECT name, sde.st_x (shape) "The ......