Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleȨÏÞ¹ÜÀí

Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ     
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ     
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø  
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§     
sqlplus sys as sysdba;//ͬÉÏ     
sqlplus scott/tiger;//µÇ½ÆÕͨÓû§scott 
Èý¡¢¹ÜÀíÓû§
Java´úÂë
create user zhangsan;//ÔÚ¹ÜÀíÔ±ÕÊ»§Ï£¬´´½¨Óû§zhangsan     
alert user scott identified by tiger;//ÐÞ¸ÄÃÜÂë 
ËÄ£¬ÊÚÓèȨÏÞ
1¡¢Ä¬ÈÏµÄÆÕͨÓû§scottĬÈÏδ½âËø£¬²»ÄܽøÐÐÄǸöʹÓã¬Ð½¨µÄÓû§Ò²Ã»ÓÐÈκÎȨÏÞ£¬±ØÐëÊÚÓèȨÏÞ
Java´úÂë
/*¹ÜÀíÔ±ÊÚȨ*/    
grant create session to zhangsan;//ÊÚÓèzhangsanÓû§´´½¨sessionµÄȨÏÞ£¬¼´µÇ½ȨÏÞ     
grant unlimited session to zhangsan;//ÊÚÓèzhangsanÓû§Ê¹Óñí¿Õ¼äµÄȨÏÞ     
grant create table to zhangsan;//ÊÚÓè´´½¨±íµÄȨÏÞ     
grant drop table to zhangsan;//ÊÚÓèɾ³ý±íµÄȨÏÞ     
grant insert table to zhangsan;//²åÈë±íµÄȨÏÞ     
grant update table to zhangsan;//Ð޸ıíµÄȨÏÞ     
grant all to public;//ÕâÌõ±È½ÏÖØÒª£¬ÊÚÓèËùÓÐȨÏÞ(all)¸øËùÓÐÓû§(public)   
2¡¢oralce¶ÔȨÏÞ¹ÜÀí±È½ÏÑϽ÷£¬ÆÕͨÓû§Ö®¼äÒ²ÊÇĬÈϲ»ÄÜ»¥Ïà·ÃÎʵģ¬ÐèÒª»¥ÏàÊÚȨ
Java´úÂë
/*oralce¶ÔȨÏÞ¹ÜÀí±È½ÏÑϽ÷£¬ÆÕͨÓû§Ö®¼äÒ²ÊÇĬÈϲ»ÄÜ»¥Ïà·ÃÎʵÄ*/    
grant select on tablename to zhangsan;//ÊÚÓèzhangsanÓû§²é¿´Ö¸¶¨±íµÄȨÏÞ     
grant drop on tablename to zhangsan;//ÊÚÓèɾ³ý±íµÄȨÏÞ     
grant insert on tablename to zhangsan;//ÊÚÓè²åÈëµÄȨÏÞ     
grant update on tablename to zhangsan;//ÊÚÓèÐ޸ıíµÄȨÏÞ     
grant insert(id) on tablename to zhangsan;     
g


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

¹â»·¾¡Ê§ OracleÔÚÖйúÈ«ÃæÔâÓö¡°»¬Ìú¬¡±

 
¼Ì9Ô·ݹúÄÚÄ³ÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ ......

OracleµÄËø»úÖÆ¹éÄÉ×ܽá

OracleµÄËø»úÖÆ¹éÄÉ×ܽá
    
ËøÊÇ·ÀÖ¹ÔÚÁ½¸öÊÂÎñ²Ù×÷ͬһ¸öÊý¾ÝÔ´£¨±í»òÐУ©Ê±½»»¥ÆÆ»µÊý¾ÝµÄÒ»ÖÖ»úÖÆ¡£Oracle²ÉÓ÷âËø¼¼Êõ±£Ö¤²¢·¢²Ù×÷µÄ¿É´®ÐÐÐÔ¡£OracleµÄËø·ÖΪÁ½´ó
ÀࣺÊý¾ÝËø£¨Ò²³ÆDMLËø£©ºÍ×ÖµäËø¡£×ÖµäËøÊÇOracle
DBMSÄÚ²¿ÓÃÓÚ¶Ô×Öµä±íµÄ·âËø¡£×ÖµäËø°üÀ¨Óï·¨·ÖÎöËøºÍDDLËø£¬ÓÉDBMSÔÚ±ØÒª ......

OracleÓαêʹÓù¥ÂÔ

Sql´úÂë
1.
´ÓÓαêÌáÈ¡Êý¾Ý
2. ´ÓÓαêʧȥһÆðÊý¾ÝÔËÓÃFETCHÏÂÁÿһ´ÎÌáÈ¡Êý¾Ýºó£¬Óα궼ָÏò½á¹û¼¯µÄÏÂÒ»Æð¡£Óï·¨Èç´Î£º
3. FETCH cursor_name INTO variable[,variable,...]
4. ÖÁÓÚSELECT¶¨ÒåµÄÓαêµÄÿһÁУ¬FETCH±äÁ¿ÁÐ±í¶¼Ó¦¸ÃÓÐÒ»¸ö±äÁ¿ÓëÖ®Ïà¶ÔÓ¦£¬±äÁ¿µÄ²¿ÀàÒ²ÒªÀ×ͬ¡£
Àý£º
5. SET SERVERIUTPUT ......

MsSql ºÍ Oracle ¿çÊý¾Ý¿â²éѯ

SQL
insert into   table_name(colum1,colum2)
select  colum1,colum2
 from  opendatasource('sqloledb','data source=·þÎñÆ÷Ãû;user id=Óû§Ãû ;password=ÃÜÂë ').database_name.dbo.table_name
ÈçÖ´ÐгöÏÖÒÔÏ´íÎó”sql server ×èÖ¹Á˶Ô×é¼þ \'ad hoc distributed queries\' µÄ·ÃÎÊ&l ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ