(ת)oracle 10g xe Îҵݲװʵ¼ù¼°¼òµ¥ÅäÖùý³Ì
Îҵݲװ¹ý³Ì
1¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unstable main non-free
2¡¢¸üÐÂÔ´ sudo apt-get update
Óöµ½ÎÊÌ⣺ W:GPG error: http://oss.oracle.com unstable Release: ÓÉÓÚûÓй«Ô¿£¬ÏÂÁÐÇ©ÃûÎÞ·¨½øÐÐÑéÖ¤£º NO_PUBKEY 2E2BCDBCB38A8516
ÎÊÌâÔÒò£º because Oracle is signing their packages with GPG and my system didn’t have their GPG public key.
½â¾ö·½°¸£ºÔËÐÐÏÂÃæÈýÌõÓï¾ä——
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle
sudo apt-key add RPM-GPG-KEY-oracle
sudo aptitude update
3¡¢°²×°client sudo apt-get install oracle-xe-client
4¡¢°²×° Oracle 10g Express Edition £¬ÔòÖ´ÐÐÃüÁ
sudo apt-get install oracle-xe
¼òµ¥ÅäÖùý³Ì
°²×°Íê³Éºó£¬ÏµÍ³Ìáʾ“-e You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.”
ÔÚÃüÁîÐÐÊäÈ룺/etc/init.d/oracle-xe configure½øÐÐĬÈÏÅäÖü´¿É£¡
×îºó½øÐÐÁ˲âÊÔ£¬Õý³£
££££££££££££££££££££££££££££££££££££
ÒÔÏÂÊÇÎÒתÔصÄһƪÎÄÕ£¬ÎÒ¾õµÃÂùºÃµÄ£¬Ìù³öÀ´¹²Ïíһϣ¬Ð»Ð»ÎÄÕÂÖ÷ÈËÀ²¡«
ÎÒÓõ½µØ·½ÓÃÇø±ðÓÚÔÎĵÄ×ÖÌå»òÕßÑÕÉ«±ê×¢Á˳öÀ´;-)
££££££££££££££££££££££££££££££££££££
£Ûת£Ýoracle 10g xe (eXpress Edition) °²×°Óë¼òµ¥Ê¹ÓÃ
1 ÔÚoracleÍøÕ¾ÉÏ
Ïà¹ØÎĵµ£º
< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboar ......
< type="text/javascript">
< type="text/javascript">
http://blog.csdn.net/tianlesoftware/archive/2009/12/01/4915223.aspx
Ò»¡¢Ê²Ã´ÊÇ
Oracle
×Ö·û¼¯
Oracle
×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ
,
ÓдóÐ¡Ö ......
OracleÌåϵ½á¹¹Öеĸ÷ÖÖÃû³Æ
¹Ø¼ü×Ö: oracle, Êý¾Ý¿âÃû, ʵÀýÃû, ÓòÃû, È«¾ÖÊý¾Ý¿âÃû, ·þÎñÃû, ÍøÂç·þÎñÃû
Ò»¡¢Êý¾Ý¿âÃû
¡¡¡¡Êý¾Ý¿âÃûÊÇÊý¾Ý¿âµÄ“Éí·ÝÖ¤ºÅÂ딣¬ÓÃÓÚ±êʾһ¸öÊý¾Ý¿â¡£ÔÚ²ÎÊýÎļþÖÐÓÃDB_NAME±íʾ¡£
¡¡¡¡Êý¾Ý¿âÃûÊÇÔÚ°²×°Êý¾Ý¿â¡¢´´½¨ÐµÄÊý¾Ý¿â¡¢´´½¨Êý¾Ý¿â¿ ......
´´½¨oracle job
oracle job¼ò½é
Ö÷ÒªµÄʹÓÃÇé¾°
¶¨Ê±ÔÚºǫִ́ÐÐÏà¹Ø²Ù×÷:ÈçÿÌìÍíÉÏ0µã½«Ò»ÕűíµÄÊý¾Ý±£´æµ½ÁíÒ»ÕűíÖÐ,2£º¶¨Ê±±¸·ÝÊý¾Ý¿âµÈ
Ê컯˵ÍòÊ¿ªÍ·ÄÑ£¬ÕâÀïÎÒÖ»¼òµ¥¼ÇÊöÒ»¸ö´´½¨Ò»¸ö¼òµ¥µÄjob
²½ÖèÈçÏ£º
1¡¢´´½¨Ò»Õűíg_test
create table G_TEST
(
ID NUMBER(1 ......
Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......