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

Oracle database£¬ create userÎÊÌ⣡£¡£¡£¡

ÎÒ´´½¨³öÏÖµÄÎÊÌâ Ï£ÍûÓÐÈ˻شðÎÒ£¬ÎÒspool½ØÈ¡ÁËÄÚÈÝ£º
SQL> create user xiaoming identified by m123
  2 
SQL> spool off

ÇëÎÊ ´´½¨Ê±ºòΪʲô»áÌáʾ2°¡£¡

ÄÇôÔõôд£¿


SQLÊÇÒÔ';'½áÊøµÄ, ÔÚûÓÐÓöµ½';'֮ǰ£¬ÏµÍ³¼ÌÐøÈÃÄãÊäÈësqlÓï¾ä£¬Ö±µ½Óöµ½';'


Ŷ ²»ºÃÒâ˼ ´ÖÐÄѽ


ºÇºÇ

ÊǵÚ2ÐеÄÒâ˼¡£

Èç¹ûÓï¾äдÍ꣬±ØÐëÒÔ  ;  ½áÊø¡£

ÎÒÏë¸øÄãÃÇÿÈË50·Ö £¬¿ÉÊÇÎÒûÓУ¡

ÒýÓÃ
ÎÒ´´½¨³öÏÖµÄÎÊÌâ Ï£ÍûÓÐÈ˻شðÎÒ£¬ÎÒspool½ØÈ¡ÁËÄÚÈÝ£º
SQL> create user xiaoming identified by m123
  2 
SQL> spool off

ÇëÎÊ ´´½¨Ê±ºòΪʲô»áÌáʾ2°¡£¡


»¹ÐèÒªÔÚºóÃæÊäÈëÄÚÈݵģ¬ËùÒÔ¸øÄãÖØÐ¿ªÁËÒ»ÐÐÀ´ÊäÈ룬ÄãºóÃæÉÙÁË";"·ûºÅ¡£


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

¹ØÓÚoracle 10gµÄsqlplus

ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390

×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ

×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ