oracleÔËÐÐÃüÁî´óÈ«
net use \\ip\ipc$ " " /user:" " ½¨Á¢IPC¿ÕÁ´½Ó
net use \\ip\ipc$ "ÃÜÂë" /user:"Óû§Ãû" ½¨Á¢IPC·Ç¿ÕÁ´½Ó
net use h: \\ip\c$ "ÃÜÂë" /user:"Óû§Ãû" Ö±½ÓµÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use h: \\ip\c$ µÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØΪH:
net use \\ip\ipc$ /del ɾ³ýIPCÁ´½Ó
net use h: /del ɾ³ýÓ³Éä¶Ô·½µ½±¾µØµÄΪH:µÄÓ³Éä
net user Óû§Ãû ÃÜÂë /add ½¨Á¢Óû§
net user guest /active:yes ¼¤»îguestÓû§
net user ²é¿´ÓÐÄÄЩÓû§
net user ÕÊ»§Ãû ²é¿´ÕÊ»§µÄÊôÐÔ
net localgroup administrators Óû§Ãû /add °Ñ“Óû§”Ìí¼Óµ½¹ÜÀíÔ±ÖÐʹÆä¾ßÓйÜÀíԱȨÏÞ,×¢Ò⣺administratorºó¼ÓsÓø´Êý
net start ²é¿´¿ªÆôÁËÄÄЩ·þÎñ
net start ·þÎñÃû ¿ªÆô·þÎñ£»(Èç:net start telnet£¬ net start schedule)
net stop ·þÎñÃû ֹͣij·þÎñ
net time \\Ä¿±êip ²é¿´¶Ô·½Ê±¼ä
net time \\Ä¿±êip /set ÉèÖñ¾µØ¼ÆËã»úʱ¼äÓë“Ä¿±êIP”Ö÷»úµÄʱ¼äͬ²½,¼ÓÉϲÎÊý/yes¿ÉÈ¡ÏûÈ·ÈÏÐÅÏ¢
net view ²é¿´±¾µØ¾ÖÓòÍøÄÚ¿ªÆôÁËÄÄЩ¹²Ïí
net view \\ip ²é¿´¶Ô·½¾ÖÓòÍøÄÚ¿ªÆôÁËÄÄЩ¹²Ïí
net config ÏÔʾϵͳÍøÂçÉèÖÃ
net logoff ¶Ï¿ªÁ¬½ÓµÄ¹²Ïí
net pause ·þÎñÃû ÔÝͣij·þÎñ
net send ip "Îı¾ÐÅÏ¢" Ïò¶Ô·½·¢ÐÅÏ¢
net ver ¾ÖÓòÍøÄÚÕýÔÚʹÓõÄÍøÂçÁ¬½ÓÀàÐͺÍÐÅÏ¢
net share ²é¿´±¾µØ¿ªÆôµÄ¹²Ïí
net share ipc$ ¿ªÆôipc$¹²Ïí
net share ipc$ /del ɾ³ýipc$¹²Ïí
net share c$ /del ɾ³ýC£º¹²Ïí
net user guest 12345 ÓÃguestÓû§µÇ½ºóÓý«ÃÜÂë¸ÄΪ12345
net password ÃÜÂë ¸ü¸ÄϵͳµÇ½ÃÜÂë
netstat -a ²é¿´¿ªÆôÁËÄÄЩ¶Ë¿Ú,³£ÓÃnetstat -an
netstat -n ²é¿´¶Ë¿ÚµÄÍøÂçÁ¬½ÓÇé¿ö£¬³£ÓÃnetstat -an
netstat -v ²é¿´ÕýÔÚ½øÐеŤ×÷
netstat -p ÐÒéÃû Àý£ºnetstat -p tcq/ip ²é¿´Ä³ÐÒéʹÓÃÇé¿ö£¨²é¿´tcp/ipÐÒéʹÓÃÇé¿ö£©
netstat -s ²é¿´ÕýÔÚʹÓõÄËùÓÐÐÒéʹÓÃÇé¿ö
nbtstat -A ip ¶Ô·½136µ½139ÆäÖÐÒ»¸ö¶Ë¿Ú¿ªÁ˵Ļ°£¬¾Í¿É²é¿´¶Ô·½×î½üµÇ½µÄÓû§Ãû£¨03Ç°µÄΪÓû§Ãû£©-×¢Ò⣺²ÎÊý-AÒª´óд
tracert -²ÎÊý ip(»ò¼ÆËã»úÃû) ¸ú×Ù·ÓÉ£¨Êý¾Ý°ü£©£¬²ÎÊý£º“-wÊý×Ö”ÓÃÓÚÉèÖó¬Ê±¼ä¸ô¡£
ping ip(»òÓòÃû) Ïò¶Ô·½Ö÷»ú·¢ËÍĬÈÏ´óСΪ32×Ö½ÚµÄÊý¾Ý£¬²ÎÊý£º“-l[¿Õ¸ñ]Êý¾Ý°ü´óС”£»“-n·¢ËÍÊý¾Ý´ÎÊý”£»“-t”Ö¸Ò»Ö±ping¡£
ping -t -l 65550 ip ËÀÍöÖ®pin
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
¡¡¡¡
¡¡¡¡±¾Êé×÷Ϊһ±¾´´×÷Ö®³õ¾Í¶¨Î»ÓÚ¼¼ÊõÓ¦ÓõÄʵ¼ù²Î¿¼Ê飬ËäȻǰǰºóºó´®ÁªÁËOracleÊý¾Ý¿âÖÐÊ®Óà¸ö³£ÓÃÌØÐÔ»ò¹¤¾ß£¬µ«ÔÚÕ½ڵÄÉè¼ÆÉÏÍêÈ«×ñÑÕâÒ»ÀíÄî¡£ÔÚÉæ¼°ÌØÐÔ»ò¹¤¾ßÓ¦ÓõÄÿһ¸öÕ½ڣ¬¾ùÓÐÏà¹ØʵÀýÑÝʾÈçºÎÓ¦Óã¬ËùÓÐʾÀýµÄ×îÖÕÄ¿µÄ£¬¾ÍÊÇÏ£ÍûÔĶÁ±¾ÊéµÄÅóÓÑ£¬Äܹ»½«Ë«ÊÖ½â·Å³öÀ´£¬×ÔÐÅÁé»îµØʹÓÃÊéÖнéÉܵĸ÷Ï ......
delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷ ......
»¹ÊǼ¸Î»¶ÁÎÒµÄÊé (¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX UNIXÉϵÄʵսÏê½â¡·) µÄ¶ÁÕßÀ´Óʼþ×ÉѯÎÊÌ⣬ºÜ±§Ç¸ÎÒ²»ÄÜÖðλ»Ø¸´Óʼþ£¬µÚÒ»ÎÒÕæµÄͦ棬µÚ¶þÕâЩÎÊÌâÆÄÓй²ÐÔ¡£ÎÒÀ´½èÖúÕâ¸öµØ·½£¬Í³Ò»µØºÍÖîλ̽ÌÖ£¬ºÜ¶àÎÊÌâÎÒÒ²ÊÇÔÚÃþË÷ÖУ¬²»ÄÜÖ±½Ó¸ø´ó¼Ò´ð°¸£¬ºÇºÇ£¬´ó¼Ò¼ûÁ°¡!
˵˵ËøÎÊÌâ¡£ MS SQLÖ§³ÖµÄËøÀàÐͺÍOracle²îÒìÊǺ ......