oracle²åÈëʱÈçºÎ²åÈëuuId
ÊÇÏëÉú³ÉGUIDÂð£¿
SQL> select sys_guid() from dual ;
SYS_GUID()
--------------------------------
F18031C69D8345DEB305D4B2E796A282
Äã¿ÉÒ԰ѱíµÄÖ÷¼ü×ֶεÄȱʡֵÉèΪsys_guid()
insert into luxian_info (id) values(sys_guid());
Ïà¹ØÎĵµ£º
Ê×ÏÈÀ´ËµOracleµÄÍøÂç½á¹¹£¬Íù¸´ÔÓ´¦ËµÄܼÓÉϼÓÃÜ¡¢LDAPµÈµÈ¡£¡£ÕâÀï²»×öÌÖÂÛ£¬Öصã·ÅÔÚ»ù±¾µÄÍøÂç½á¹¹Ò²¾ÍÊÇÎÒÃÇ×î³£ÓõÄÕâÖÖÇé¿ö
¡¡¡¡
¡¡¡¡Èý¸öÅäÖÃÎļþ
¡¡¡¡
¡¡¡¡listener.ora¡¢sqlnet.ora¡¢tnsnames.ora £¬¶¼ÊÇ·ÅÔÚ$ORACLE_HOME\network\adminĿ¼Ï¡£
¡¡¡¡
¡¡¡¡Öصã:Èý¸öÎļþµÄ×÷ÓúÍʹÓÃ
¡¡¡¡
¡¡¡¡#------- ......
ÔÚORACLEÖо³£»áÅöµ½×èÈûµÄÇé¿ö·¢Éú£¬Õâ¸öʱºòÎÒÃǾÍÐèÒª¿ìËÙµÄÕÒ³öµ¼ÖÂ×èÈûµÄÔÒò£¬²¢¾¡¿ìÅųýËü£¬ºÃÈÃÏµÍ³ÖØÐÂÕý³£ÔËÐС£
ÏÂÃæÒÔËÀËøÎªÀý£¬À´¿´¿´ÈçºÎÕÒ³öµ¼ÖÂ×èÈûµÄ»á»°²¢½â¾öÎÊÌâ¡£
//SCOTT´°¿Ú1
SQL> select * from t2;
ID
----------
3
1
2
SQL> update t2 set i ......
ÏîÄ¿ÖУ¬ÐèÒª½¨Á¢×ÔÔö³¤×ֶΣ¬µ«Åöµ½oracle±¾Éí²»Ö§³Ö´ËÖÖÀàÐ͵Ä×ֶΣ¬Ö»ºÃÓñðµÄ°ì·¨¡£
ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ£¨×ª£©
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
&nbs ......
ÔÚ¿ªÊ¼Ö®Ç°£¬ÐèÒª¼òµ¥ËµÃ÷һϣ¬Ä¿Ç°¹«Ë¾Óм¸¸öÏîÄ¿¶¼²ÉÓÃOracle×÷ΪÊý¾Ý¿âƽ̨£¬²¢ÇÒÓеÄÏîĿʹÓõ½ÁËOracleµÄÊý¾Ý¿â¸´ÖƼ¼Êõ£¬ÆäÖÐÒ²Óöµ½ÁËһЩÎÊÌ⣬Òò´ËÔÚÕâÀÎÒ¶ÔOracleµÄ¸´ÖƼ¼Êõ̸һÏÂÎÒ¸öÈ˵ÄÀí½â£¬Ï£ÍûÄܹ»¶Ô²ÉÓÃOracleÊý¾Ý¿âµÄÏîÄ¿×éÓÐËù°ïÖú¡£ÆäÖÐÔÚÎÄÖÐʹÓõ½µÄSQL½Å±¾¶¼ÊǾ¹ý¼ìÑé¿ÉÒÔÔËÐеġ£
¡¡¡¡Ê ......