¸÷λ¸ßÈËÎʸö¼òµ¥ÎÊÌ⣻
ÎÒÓÃSYSµÇ¼£»ÏÂÃæÕâ¾ä
select * from dba_data_files
²éµ½ÁËÏÂÃæµÄ¼Ç¼G:\ORACLE\DATE1_01.DBF
G:\ORACLE\INDEX1_01.ORA
G:\ORACLE\UNDO01_01.DBF
µ«ÎÒÓÃÏÂà ......
sql server 2000 ÓÃDTS µ¼Êý¾Ýµ½ oracle 10g ʱ×ÜÊÇÌáʾ ¡®Óû§ system²»´æÔÚ¡¯£¿ÊÇʲôÔÒò¿©£¬Óà sysÓû§Ò²ÊÔÁË£¬¶¼²»¿ÉÒÔ
°ï¶¥...ORACLE²»ÊìϤ
SQL code:
---
ÏȰÑms µ¼³É excel,ÔÙÓÉexcelµ¼³É
oracle,ÅжÏÊÇoracleûÓÐÉèÖú㬻¹ÊÇmsms..
ÊDz»ÊÇoracleÓëSQLÖ®¼äµÄÓ³ÉäûÓн¨Á¢ºÃ
»¹ÊÇoracleµÄ¼àÌýûÓÐÉ ......
Õâ¸ö¹ý³ÌÊÇÓÃPLSQL Developer дµÄ, ΪʲôÔÚ"procedures"Ŀ¼ÏÂ,ͼ±êÉÏÃæ×ÜÊÇÓÐÒ»¸öºìÉ«µÄ"X"
create or replace procedure p_AddAction
(v_name in VARCHAR2(50),
v_desc in VARCHAR2(200),
v_AffectRow out int
)
is
begin
insert into tb_action
&nb ......
ÎÒÏë²éѯÁеÄÈçÏÂÐÅÏ¢£º
ÊÇ·ñΪÖ÷¼ü ÊÇ·ñ¿ÉΪ¿Õ ÊÇ·ñΨһ Ãû³Æ Êý¾ÝÀàÐÍ ³¤¶È ĬÈÏÖµ
ÇëÎʸÃÔõôд£¿
ÎÒÏë²éѯº¯Êý¼°´æ´¢¹ý³ÌµÄ´úÂ룬¸ÃÔõôд£¿
¸öÈËÈÏΪȥOracle×¨ÇøÎʵϰ£¬´ð°¸³öµÃ¿ì....
´¿°ï¶¥£¬Ó¦¸ÃÖ»ÊÇÄÚ²¿º¯Êýµ÷ÓõÄÎÊÌâ°É..
лÁË£¬
ÉÏ´ÎÓиöÎÊÌâÁ½±ß¶¼ÎÊÁË£¬½á¹û»¹ÊÇÕâ±ßºÃЩ¡£
......
¿Í»§ÒªÇ󱨸æÊý¾Ý¿âµÄ°²È«ÐÔ£¬°üÀ¨Â©¶´É¨Ãè½á¹û¡£
ÇëÎÊÓÐoracleµÄ©¶´É¨Ã蹤¾ßÂð£¿ÓÐÈËÓùýÂð£¿
¸Ð¾õ²Ù×÷ϵͳÊǵÚÒ»´ó·ÀÏß
Êý¾Ý¿â°²È«Ã»Óп¼Âǹý
µ½metalinkÉÏ´´½¨¸ötar£¬ ÎÊÌâ¾Íд£º oracle xx°æ±¾ ÏÖÔڵݲȫ©¶´ÓÐÄÄЩ£¬ÈçºÎɨÃè?
żҲ³õѧoracle,°ïÄã¶¥
ÒýÓÃ
µ½metalinkÉÏ´´½¨¸ötar£¬ Î ......
ÎÒÏÖÔÚÓÐÒ»¸öÖÐÐÄ¶Ë ÊÇoracleÊý¾Ý¿â¡£
ÏÖÔÚÖÐÐÄÏë¸üпͻ§¶ËµÄoracleÊý¾Ý¿âÖеÄij¸ö±í¡£ÏÖÔÚÓкܶà¸ö¿Í»§¶Ë£¬¿Í»§¶ËµÄip¶ÎÊÇ192.168.1.0-192.168.1.255
Ôõô²ÅÄÜʵÏÖÕâÑùµÄÒ»¸ö¹¦Äܰ¡£¿
ÎÒÏÖÔÚÏëÁËÒ»¸ö×î²»ºÃµÄ·½·¨¡£
¾ÍÊÇ
Java code:
public static Connection getConnections(String ip) {
/ ......