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

hibernate Oracle sequenceÎÊÌâ

ÏÖÔÚÊÇÕâÑùµÄ¡£ÎÒ±íÖеÄÖ÷¼üÊÇjjdm,µ«oracleʹÓÃÁËÖ÷¼û ¾Í±ØÐëÒªÓÐsequence¡£ÎҾͽ¨ÁËÒ»¸ö¡£µ«hbm.xml ÔõôÅäÖÃÄØ
        <id name="id" type="java.lang.Integer">
            <column name="ID" length="8" precision="22" scale="0"/>
            <generator class="sequence">
              <param name="sequence"/>
        </generator>
        </id>
        <property name="jjdm" type="java.lang.String">
            <column name="JJDM" length="10"/>
        </property>

µ«hbmÎļþÖÐ <id> </id>²ÅÊÇÖ¸¶¨Ö÷¼üµÄ¡£¶øÎÒµÄJJDMÊÇÖ÷¼ü¡£Ó¦¸ÃÔõôÅäÖÃÄØ
¼±Çó............
<id name="jjdm" type="java.lang.Long">
            <column name="JJDM" precision="22" scale="0" />
            <generator class="sequence">
            <param name="sequence">sequence_name </param>
    &nbs


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

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

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

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

ORACLE°²×°ÎÊÌâ

oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨

µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö

ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......

sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔ­Àí£¿

sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
    conn system/oracle£¨ÃÜÂ룩

Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔ­ÀíÉÏ£©

Èç¹ûÓÐË­¶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ