oracle 10gÖкÜÆæ¹ÖµÄµ¥ÒýºÅÎÊÌâ
oracleÖУ¬
±í½á¹¹ÈçÏ£º
create table device
(
id number(10) not null primary key,
dept varchar2(50) not null
)
tablespace users
/
Òª½«dept×ֶθüгÉÈçÏÂÄÚÈÝ£ºselect * from message where name='tom'
ÎÒÊÔ¹ýʹÓÃÈçϵĸüÐÂÓï¾ä²»ÐУºupdate device set dept='select * from message where name='tom' ' ;
¸ÃÈçºÎ×öÄØ£¿
½â¾ö·½·¨£º
update device set dept='select * from message where name=' 'tom' ' where id=3' ;
Ö´Ðгɹ¦¡£
ÔÀ´£¬ÊÇÓÃÁ½¸ö'±íʾÁËÒ»¸ö'Ëü´óÒ¯°¡¡£¡£¡£¡£Ê²Ã´¹·Æ¨Óï·¨°¡¡£¡£¡£¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
£±£º´´½¨»·¾³±äÁ¿
¡¡¡¡export $ORACLE_HOME $ORACLE_SID£¨×¼±¸½¨Á¢µÄÊý¾Ý¿âµÄSID)
£²£º½¨Á¢³õʼ»¯²ÎÊýÎļþ
¡¡¡¡$ORACLE_HOME/dbs/init$ORACLE_SID.ora (¿ÉÒÔ´ÓÒѾ½¨ºÃµÄ¿âÀïÃæÄÃ,ͨ³£ÔÚpfile ÀïÃ棩,Ò²¿ÉÒÔ×Ô¼º½¨£º
¡¡¡¡control_files = ($ORACLE_HOME/oradata/$ORACLE_SID/control1.ctl,$ORACLE_HOME/oradata/$ORACLE ......
ÊÖÍ·ÕýÔÚ½øÐÐÒ»¸öÏîÄ¿£¬ÐèҪȫÎļìË÷£¬¾¹ýͬÊÂ×ÐϸËÑË÷·¢ÏÖ£ºoracleÌṩoracle textµÄÈ«ÎļìË÷¹¦ÄÜ¡£
oracle textµÄ¼òµ¥Ó¦ÓþͬʲâÊÔ½á¹ûÕý³££¬°´ÕÕÏîÄ¿ÒªÇó(ÏîÄ¿Ô¤¶¨·½°¸wordÎĵµ´æÈëÊý¾Ý¿â(blobÀàÐÍ))ʹÓÃoracle text²éѯ½á¹ûÈ·ÊÇΪ¿Õ£¬Í¬ÊÂÑо¿µ½´ËÖжϡ£
  ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£ ......
Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌض¨Óû§£¬ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ ......