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

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ѧϰ±Ê¼ÇһʵÀý


Oracleѧϰ±Ê¼ÇһʵÀý
             ——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
 
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
     ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
     ÔÚSql ......

½â¾öoracle¿Í»§¶ËÂÒÂë——SQLPLUSÂÒÂë½â¾ö

Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......

oracle 10.2.0.4 patchµÄÏÂÔصØÖ·Áбí

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Ìåϵ½á¹¹Öеĸ÷ÖÖÃû³Æ
¹Ø¼ü×Ö: oracle, Êý¾Ý¿âÃû, ʵÀýÃû, ÓòÃû, È«¾ÖÊý¾Ý¿âÃû, ·þÎñÃû, ÍøÂç·þÎñÃû


Ò»¡¢Êý¾Ý¿âÃû
¡¡¡¡Êý¾Ý¿âÃûÊÇÊý¾Ý¿âµÄ“Éí·ÝÖ¤ºÅÂ딣¬ÓÃÓÚ±êʾһ¸öÊý¾Ý¿â¡£ÔÚ²ÎÊýÎļþÖÐÓÃDB_NAME±íʾ¡£
¡¡¡¡Êý¾Ý¿âÃûÊÇÔÚ°²×°Êý¾Ý¿â¡¢´´½¨ÐµÄÊý¾Ý¿â¡¢´´½¨Êý¾Ý¿â¿ ......

½«Êý¾Ý¿âµÄSQL½Å±¾Îļþµ¼Èëµ½oracleÖÐ

#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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ