oracleѧϰ±Ê¼Ç——ÊÓͼ
1.ÊÓͼ£¨VIEW£©
1.1 ¸ÅÄî
ÊÓͼ-----ÊÇÓÉSELECT²éѯÓï¾ä(¿ÉÒÔÊǵ¥±í»òÕ߶à±í²éѯ)¶¨ÒåµÄÒ»¸ö"Âß¼±í",Ö»Óж¨Òå¶øÎÞÊý¾Ý,ÊÇÒ»¸ö"Ðé±í". ÔÚ´´½¨ÊÓͼʱ,Ö»Êǽ«ÊÓͼµÄ¶¨ÒåÐÅÏ¢±£´æÔÚÊý¾Ý×ÖµäÖÐ, ¶ø²¢²»½«Êµ¼ÊµÄÊý¾Ý¸´ÖƵ½Èκεط½, ¼´²»ÐèÒªÔÚ±í¿Õ¼äÖÐΪÊÓͼ·ÖÅä´æ´¢¿Õ¼ä. ÊÓͼÊDz鿴ºÍ²Ù×Ý»ù±íÊý¾ÝµÄÒ»ÖÖ·½·¨, ¿ÉÒÔÏñʹÓñíÒ»ÑùʹÓÃÊÓͼ.
tips: ²éѯÊÓͼûÓÐʲôÏÞÖÆ, ²åÈë/¸üÐÂ/ɾ³ýÊÓͼµÄ²Ù×÷»áÊܵ½Ò»¶¨µÄÏÞÖÆ; ËùÓÐÕë¶ÔÊÓͼµÄ²Ù×÷¶¼»áÓ°Ïìµ½ÊÓͼµÄ»ù±í; ΪÁË·ÀÖ¹Óû§Í¨¹ýÊÓͼ¼ä½ÓÐ޸Ļù±íµÄÊý¾Ý, ¿ÉÒÔ½«ÊÓͼ´´½¨ÎªÖ»¶ÁÊÓͼ(´øÉÏwith read onlyÑ¡Ïî).
ÊÓͼÖеÄÊý¾Ý»áËæ»ù±íµÄ¸üжø×Ô¶¯¸üÐÂ.
ÊÓͼÓÌÈç»ù±íµÄÒ»¸ö"´°¿Ú", ͨ¹ýÕâ¸ö"´°¿Ú", ¿ÉÒÔʵʩÐí¶à¹ÜÀí. ÔÚÒ»¸öÊÓͼÖпÉÒÔ¶¨ÒåµÄ×î´óÁÐÊýΪ1000, Óë±íµÄÏÞÖÆÏàͬ.
ÊÓͼԼÊø: ÔÊÐíÔÚÊÓͼÉÏÉú³ÉÔ¼Êø, Èç"Ö÷¼üÔ¼Êø¡¢Î¨Ò»¼üÔ¼Êø¡¢Íâ¼üÔ¼Êø¡¢¼ì²éÔ¼Êø"µÈ. µ«ÊÓͼÉϵÄÔ¼Êø²»ÊÇÇ¿ÖÆÐÔµÄ, ¶øÊÇÉùÃ÷ÐÔµÄ. ÊÓͼԼÊøµÄÓï·¨Óë±íÏàͬ. ÔÚ´´½¨ÊÓͼʱ, ¿ÉÒÔʹÓÃwith check optionÑ¡Ïî,¸øÊÓͼ¶¨ÒåcheckÔ¼Êø,ʹÆäÖ»Äܲéѯ¡¢²Ù×÷Âú×ãcheckÔ¼ÊøµÄ¼Ç¼ÐÐ.
1.2 ×÷ÓÃ
1)Ìṩ¸÷ÖÖÊý¾Ý±íÏÖÐÎʽ, ¿ÉÒÔʹÓø÷ÖÖ²»Í¬µÄ·½Ê½½«»ù±íµÄÊý¾ÝÕ¹ÏÖÔÚÓû§ÃæÇ°, ÒÔ±ã·ûºÏÓû§µÄʹÓÃÏ°¹ß(Ö÷ÒªÊÖ¶Î: ʹÓñðÃû).
2)Òþ²ØÊý¾ÝµÄÂß¼¸´ÔÓÐÔ²¢¼ò»¯²éѯÓï¾ä, ¶à±í²éѯÓï¾äÒ»°ãÊDZȽϸ´ÔÓµÄ, ¶øÇÒÓû§ÐèÒªÁ˽â±íÖ®¼äµÄ¹Øϵ, ·ñÔòÈÝÒ×д´í; Èç¹û»ùÓÚÕâÑùµÄ²éѯÓï¾ä´´½¨Ò»¸öÊÓͼ, Óû§¾Í¿ÉÒÔÖ±½Ó¶ÔÕâ¸öÊÓͼ½øÐÐ"¼òµ¥²éѯ"¶ø»ñµÃ½á¹û. ÕâÑù¾ÍÒþ²ØÁËÊý¾ÝµÄ¸´ÔÓÐÔ²¢¼ò»¯Á˲éѯÓï¾ä. ÕâÒ²ÊÇoracleÌṩ¸÷ÖÖ"Êý¾Ý×ÖµäÊÓͼ"µÄÔÒòÖ®Ò»,all_constraints¾ÍÊÇÒ»¸öº¬ÓÐ2¸ö×Ó²éѯ²¢Á¬½ÓÁË9¸ö±íµÄÊÓͼ(ÔÚcatalog.sqlÖж¨Òå).
3)Ö´ÐÐijЩ±ØÐëʹÓÃÊÓͼµÄ²éѯ. ijЩ²éѯ±ØÐë½èÖúÊÓͼµÄ°ïÖú²ÅÄÜÍê³É. ±ÈÈç, ÓÐЩ²éѯÐèÒªÁ¬½ÓÒ»¸ö·Ö×éͳ¼ÆºóµÄ±íºÍÁíÒ»±í, Õâʱ¾Í¿ÉÒÔÏÈ»ùÓÚ·Ö×éͳ¼ÆµÄ½á¹û´´½¨Ò»¸öÊÓͼ, È»ºóÔÚ²éѯÖÐÁ¬½ÓÕâ¸öÊÓͼºÍ
Ïà¹ØÎĵµ£º
Oracleѧϰ±Ê¼ÇһʵÀý
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
ÔÚSql ......
Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......
oracle 10.2.0.4 patchµÄÏÂÔصØÖ·Áбí
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://d ......
OracleÌåϵ½á¹¹Öеĸ÷ÖÖÃû³Æ
¹Ø¼ü×Ö: oracle, Êý¾Ý¿âÃû, ʵÀýÃû, ÓòÃû, È«¾ÖÊý¾Ý¿âÃû, ·þÎñÃû, ÍøÂç·þÎñÃû
Ò»¡¢Êý¾Ý¿âÃû
¡¡¡¡Êý¾Ý¿âÃûÊÇÊý¾Ý¿âµÄ“Éí·ÝÖ¤ºÅÂ딣¬ÓÃÓÚ±êʾһ¸öÊý¾Ý¿â¡£ÔÚ²ÎÊýÎļþÖÐÓÃDB_NAME±íʾ¡£
¡¡¡¡Êý¾Ý¿âÃûÊÇÔÚ°²×°Êý¾Ý¿â¡¢´´½¨ÐµÄÊý¾Ý¿â¡¢´´½¨Êý¾Ý¿â¿ ......
#1. Ê×ÏÈÒÔ¹ÜÀíÔ±µÄÉí·ÝµÇ¼µ½oracleϵͳÖÐ
cmd;
sqlplus sys/sys as sysdba;
#2.´´½¨Óû§test,ÃÜÂëΪtest
create user test identified by test;
#3.´´½¨±í¿Õ¼ä,ÔÚDÅÌϽ¨Á¢50mµÄ±í¿Õ¼ädata_dbf
create tablespace ts_tablespace datefile 'D:\data_dbf' size 50m;
#4.ΪÓû§·ÖÅä±í¿Õ¼ä
alter user test default t ......