ORACLEÊý¾Ý¿â±íµÄ²Ù×÷
×î½üæÓÚ¹«Ë¾µÄÏîÄ¿¿ª·¢£¬ºÜ¾ÃûÓÐÀ´csdnÁË¡£½ñÌìÎÞÊ£¬ÉÏÀ´Ð´µã¶«Î÷¡£¹©´ó¼Ò²Î¿¼£¬²»¶ÔµÄµØ·½»¹Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£
Ò»ÏÂÊǶÔoracleÊý¾Ý¿â±íµÄһЩ²Ù×÷Óï¾ä£º
ÒѾ½¨ºÃµÄ±íÌí¼Ó×Ö¶Î
alter table Tablename add(column1 varchar2(20) default 'Y',column2 number(7,2)...)
ɾ³ý×ֶΣº
alter table Tablename drop column assessment_methods
Ϊ×Ö¶ÎÌí¼Ó×¢ÊÍ£º
comment on column bill_result.bill_no is 'Ãû´Î';
Ð޸ıíµÄ×Ö¶ÎÃû³Æ
ALTER TABLE table_name RENAME COLUMN column1 TO column2;
--Ϊ±ítablename1 µÄis_deletedÁÐÌí¼ÓĬÈÏÖµ
alter table tablename1 modify is_deleted default 'N'
Ïà¹ØÎĵµ£º
£¨´ËƪÎÄÕÂÖ»ÐèÒªÁ˽â¼È¿ÉÒÔÁË£©
ǶÌ×±í
¶¨Ò壺ÔÚÒ»¸ö±íÖл¹°üº¬ÁíÍâÒ»¸ö×Ó±í¡£
Êý¾Ý¿âÔÚ´´½¨Êý¾Ý±íµÄʱºò¶¼ÒªÖ¸¶¨×ֶεÄÀàÐÍ£¬ËùÒÔǶÌ×±í±¾ÉíÒ²ÐèҪͬÑùÖ¸¶¨ÀàÐÍ£¬ËùÒÔÕâÖÖÀàÐÍÐèÒªµ¥¶À¶¨Òå¡£
´´½¨ÀàÐÍÓï·¨£ºcreate type project_ty as object£¨
......
¡¡
¡¡¡¡1. ʹÓÃ%TYPE
¡¡¡¡ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿£º
¡¡¡¡DECLARE
¡¡¡¡ v_FirstName VARCHAR2(20);
¡¡
¡¡µ«ÊÇÈç¹ûfirst_nameÁе͍Òå¸Ä±äÁ ......
°²×°£º
ÔËÐÐG:\install\setup.exe°²×°Oracle£¬µ«²»´´½¨Æô¶¯Êý¾Ý¿â
´´½¨Êý¾Ý¿â(ʹÓÃConfiguration And Migration Tools->DataBase Configuration Assistant)
´´½¨¼àÌý³ÌÐò(ʹÓÃConfiguration And Migration Tools->NetManager»òÕß Configuration And Migration Tools->Net Configuration Assistant)
´´½¨·þÎñ ......
´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂÊ¹Ó ......