Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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°¡£¡


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


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

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

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

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ