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

oracleÊý¾ÝÀàÐÍnumber

OracleʹÓñê×¼¡¢¿É±ä³¤¶ÈµÄÄÚ²¿¸ñʽÀ´´æ´¢Êý×Ö¡£Õâ¸öÄÚ²¿¸ñʽ¾«¶È¿ÉÒԸߴï38λ¡£
    NUMBERÊý¾ÝÀàÐÍ¿ÉÒÔÓÐÁ½¸öÏÞ¶¨·û£¬È磺
    column NUMBER £¨ precision£¬ scale£©
    precision±íʾÊý×ÖÖеÄÓÐЧλ¡£Èç¹ûûÓÐÖ¸¶¨precisionµÄ»°£¬Oracle½«Ê¹ÓÃ38×÷Ϊ¾«¶È¡£
    scale±íʾÊý×ÖСÊýµãÓұߵÄλÊý£¬scaleĬÈÏÉèÖÃΪ0.¡¡¡¡Èç¹û°ÑscaleÉè³É¸ºÊý£¬Oracle½«°Ñ¸ÃÊý×ÖÈ¡ÉᵽСÊýµã×ó±ßµÄÖ¸¶¨Î»Êý¡£


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle²åÈëʱÈçºÎ²åÈëuuId

 ÊÇÏëÉú³ÉGUIDÂð£¿
SQL> select   sys_guid() from dual ;
SYS_GUID()
--------------------------------
F18031C69D8345DEB305D4B2E796A282
Äã¿ÉÒ԰ѱíµÄÖ÷¼ü×ֶεÄȱʡֵÉèΪsys_guid()
insert into luxian_info (id) values(sys_guid()); ......

ORACLE ÄÚ´æ¹ÜÀí


Oracle 9i¶¯Ì¬SGA¹ÜÀí
ÔÚOracle 9iÖУ¬¿ÉÒÔÉèÖÃSGA_MAX_SIZE£¬¸Ã²ÎÊýÓÃÒÔ¿ØÖƸ÷»º³å³ØʹÓõÄÄÚ´æ×ܺͣ¬±¾ÖÊÉÏÊÇÔÚ½ø³ÌÖÐÔ¤ÏÈ·ÖÅäÒ»¶ÎÐéÄâµØÖ·±¸Óöø²»·ÖÅäÎïÀíÄڴ棬ĿµÄÊÇ·ÀÖ¹ºÍ½ø³Ç˽ÓеØÖ·¶ÎµÄ³åÍ»¡£
Ö»Òª×ܵÄSGAÄÚ´æÉèÖò»³¬¹ýSGA_MAX_SIZEµÄÉèÖ㬸ü¸Ä¶¼¿ÉÒÔÁ¢¼´ÉúЧ¡£ÐèҪעÒâµÄÊÇ£¬ÔÚOracle 9iR1ÖУ¬¶¯Ì¬¼õСÄÚ´ ......

oracle»ù´¡ÈëÃŽ̲Ä

 
½¨±í
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
    [default value] [prima ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ