oracle ÐÞ¸Ä×Ö¶ÎÀàÐ͵ķ½·¨
½ñÌ칫˾ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter table tb_test modify permile number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set permile_temp=permile;
alter table drop column permile;
alter table test rename column permile_temp to permile;
ÕâÖÖ·½·¨»áʹÁÐÃû·¢Éú±ä»¯,¶øÇÒ×Ö¶Î˳ÐòÔö¼Ó ÓпÉÄÜ·¢ÉúÐÐÇ¨ÒÆ,¶ÔÓ¦ÓóÌÐò»á²úÉúÓ°Ïì
ÒÔÏ·½·¨ÊDZȽϺõķ½·¨
²»ÓÃʹÁÐÃû·¢Éú±ä»¯ Ò²²»»á·¢Éú±íÇ¨ÒÆ,µ«Õâ¸öÓиöȱµãÊDZíÒª¸üÐÂÁ½´Î
Èç¹ûÊý¾ÝÁ¿½Ï´óµÄ»° ²úÉúµÄundoºÍredo¸ü¶à ,ǰÌáÒ²ÊÇҪͣ»ú×ö
ÒªÊDz»Í£»úµÄ»° ,Ò²¿ÉÒÔ²ÉÓÃÔÚÏßÖØ¶¨Ò巽ʽÀ´×ö
ÒÔÏÂÊǽű¾:
-- Ìí¼ÓÒ»¸öÁÙʱÁÐpermile_temp ÀàÐÍΪ number
alter table tb_test add permile_temp number;
-- ÉèÖÃÒª¸Ä¶¯µÄÁÐpermile ¿ÉÒÔΪNULL
alter table tb_test modify permile null;
-- °Ñpermile ÁеÄֵȫ²¿¸üиøÁÙʱÁÐpermile_temp£¬È»ºó°Ñ permile ¸üÐÂΪNULL
update tb_test set permile_temp=permile,permile=null;
commit;
-- °ÑÁÐÄ¿±êÁÐ permile Êý¾ÝÀàÐ͸Ķ¯Îªnumber(5,2)
alter table tb_test modify permile number(5,2);
-- °Ñpermile ÁеÄֵȫ²¿¸üлØÀ´£¬È»ºó°Ñ ÁÙʱÁÐ ¸üÐÂΪNULL
update tb_test set permile=permile_temp,permile_temp=null;
commit;
-- ×îºóɾ³ýÌí¼ÓµÄÁÙʱÁÐ
alter table tb_test drop column permile_temp;
-- ×îºó»¹ÔÁÐ permile ²»ÔÊÐíΪNULL
alter table tb_test modify permile not null;
select * from tb_test ;
Ïà¹ØÎĵµ£º
ÔÚÍøÉÏËÑË÷Á˰ëÌ죬Ö÷ÒªÔÒòÊÇoci.dllÊÇ64λµÄ,¶øPL/SQL developerÖ»ÓÐ32λµÄ,ÔÚʹÓÃ64λoci.dllÎļþʱ³ö´í.
ÔÚÍøÉÏÕÒÁ˺ܶà×ÊÁÏ,×î·½±ãµÄ½â¾ö·½°¸ÈçÏÂ:
1.µ½oracle¹ÙÍøÏÂÔØOracle InstantClient,ÎÒϵÄÊÇinstantclient-basiclite-win32-10.2.0.4.zip,°ÑËü½âѹËõµ½
oracle°²×°Ä¿Â¼productÏÂ,ÆäÖл¹ÓÐÒ»¸öĿ¼Ϊ10.2.0. ......
10053ʼþÊÇoracleÌṩµÄÓÃÓÚ¸ú×ÙsqlÓï¾ä³É±¾¼ÆËãµÄÄÚ²¿Ê¼þ£¬
ËüÄܼÇÔØCBOģʽÏÂoracleÓÅ»¯Æ÷ÈçºÎ¼ÆËã sql³É±¾£¬Éú³ÉÏàÓ¦µÄÖ´Ðмƻ®¡£
ÈçºÎÉèÖÃ10053ʼþ
ÉèÖñ¾sessionµÄ10053
¿ªÆô£º
Alter session set events’10053 trace name context forever[,level {1/2}]’;
¹Ø±Õ£º
Alter session set events& ......
¶Ô×óÁ¬½Ó¡¢ÓÒÁ¬½ÓµÄÒÉ»óµÃµ½½â¾ö¡£
ÔÚOracle PL-SQLÖУ¬×óÁ¬½ÓºÍÓÒÁ¬½ÓÒÔÈçÏ·½Ê½À´ÊµÏÖ
²é¿´ÈçÏÂÓï¾ä£º
SELECT emp_name, dept_name
FORM Employee, Department
WHERE Employee.emp_deptid(+) = Department.deptid
´ËSQLʹÓÃÁËÓÒÁ¬½Ó£¬¼´“(+)”ËùÔÚλÖõÄÁíÒ»²àΪÁ¬½Óµ ......
ÔÚÒ»°ãSelectÓï¾äÖÐÎÒÃÇͨ¹ýOrder by ...Asc/DescÀ´½øÐÐÅÅÐò¡£µ«ÊÇÕâÖÖÅÅÐò·½Ê½ÔÚÊä³öʱ£¬²»°üº¬ÅÅÐòºóµÄÐòºÅÐÅÏ¢¡£
ÏÖÔÚ½éÉÜÒ»ÏÂOracleÖпÉÒÔÓÃÓÚÅÅÐòÊä³öµÄ·½·¨¡£
1. RANK ( ) OVER ( [query_partition_clause] order_by_clause )
RANK ( ) OVER ( [query_p ......
[root@localhost bin]# pwd
/usr/local/bin
[root@localhost bin]# ls
coraenv dbhome oraenv
[root@localhost bin]#
[root@localhost etc]# ls -la ora*
-rw-r--r-- 1 root root 60 2008-09-19 oraInst.loc
-rw-rw-r-- 1 oracle oinstall 731 2008-09-19 or ......