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

ÇóÖúoracleÈëÃÅ֪ʶ

±¾ÈËÖ»ÊìϤsql server,×î½üÏÂÔØÁËÒ»¸öoracle,ºÍPL/SQL,¿ÉÊÇÆô¶¯ºóÒªÊäÈëÕʺźÍÃÜÂë,ÎҼǵÃÓÃsa×÷ΪÃÜÂë,ÕʺÅÎÒÊäÈëÁË
orcl,¿ÉÊÇÁ¬½Ó²»ÉÏ,ÇóÖúÈçºÎÁ¬½ÓºÍÏà¹ØµÄ×î»ù±¾ÈëÃÅ×ÊÁÏ,лл
Oracle°²×°·ÖΪ·þÎñ¶ËºÍ¿Í»§¶Ë

Èç¹ûÄãÊǽøÈ˼ÒÒѾ­½¨ºÃµÄ¿â,Ò²¾ÍÊǷDZ¾»úµÄÊý¾Ý¿â,ÄÇôװ¿Í»§¶Ë.

Èç¹ûÄã½ø×Ô¼ºµÄ,ÄÇô¿Í»§¶ËºÍ·þÎñ¶Ë¶¼ÐèҪװ.²¢ÇÒÒª°²×°×Ô¼ºµÄÊý¾Ý¿â.ÔÚ¿ªÊ¼->³ÌÐò->Oracle->ÅäÖúÍÒÆÖ²¹¤¾ß->Database Conif....Ï´´½¨Êý¾Ý¿â.

´´½¨¹ý³ÌÖÐ»á¸øÄãÒ»×éÕÊ»§,ÈÃÄãÌîдÃÜÂë,ÆäÖаüÀ¨sysºÍsysmanµÈ.È»ºóÊäÈëÃÜÂë,¼Çס¾ÍºÃÁË.

È»ºóÓÃPLSQLµÇ½.
Óû§ÃûÊÇsys
ÃÜÂëÊÇÄã¸ÕÊäÈëµÄÃÜÂë
sid(Ò²¾ÍÊÇ·þÎñÃû)ΪÄã×°Êý¾Ý¿âʱÈÃÄãÌîµÄ"È«¾ÖSID"(¾ßÌåÎÒÍü¼ÇÁ˾ÍÊÇÈ«¾ÖÊý¾Ý¿â»¹ÊÇʲôµÄ)
È»ºóÄã¾Í¿ÉÒÔÒÔDBAµÄÉí·ÝµÇ½ÁË

»òÕßÄãÔÚcmdÀï´òÈçÏÂÃüÁî
sqlplus /nolog
È»ºóÔÙ´ò
connect sys/ÃÜÂë as sysdba
Ò²¿ÉÒÔ

лл,¿´À´ÎÒҪжµôÖØÐ°²×°ÁË,ÎÒÈ¥ÊÔÊÔ

ÒýÓÃ
лл,¿´À´ÎÒҪжµôÖØÐ°²×°ÁË,ÎÒÈ¥ÊÔÊÔ

²»Êǰɣ¬ÄãÏëжµô֨װ£¡ÎÒ×°ÁËÊ®¼¸±é¶¼Ã»×°ÉÏ£¡

oracleÐ¶ÔØ±È½ÏÂé·³£¬ÒªÉ¾³ý×¢²á±íÀïµÄһЩ¼üÖµ

ÎªÊ²Ã´ÒªÖØ×°°¡£¿

²»Ò»¶¨Ö»ÓÐ֨װ°É£¬ÏÂÒ»²½°²×°¾ÍÐÐÁË¡£

¼ì²éÊÇ·ñ´ò¿ªoracle¼àÌý.

ÒýÓÃ
ÒýÓà 2 Â¥ nj_zx999 µÄ»Ø¸´:
лл,¿´À´ÎÒҪжµôÖØÐ°²×°ÁË,ÎÒÈ¥ÊÔÊÔ

²»Êǰɣ¬ÄãÏëжµô֨װ£¡ÎÒ×°ÁËÊ®¼¸±é¶¼Ã»×°ÉÏ£¡

ºÇºÇ£¬Í¬¸Ð£¬ÎÒҲŪÁËÁ½Ìì²Å×°ÉÏ
{


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ