ÎÒÊÇѧ SQL Server µÄÏÖÔÚÏëѧOracle ÇëÎʸ÷λÓÐûÓкõÄÊé½éÉÜһϠлÁË
LZ ¹þ¹þ ÎÒ½ñÌìÒ²¸ÕÓÐÕâ¸öÏë·¨ ÎÒÒ²ÊÇѧ SQLµÄ ´óϺÃǽéÉܼ¸±¾µç×ÓÊéѽ
¾«Í¨Oracle10g SQLºÍPL\SQL
Oracle+SQL±Ø±¸²Î¿¼
Oracle10GÈëÃÅÓëʵ¼ù
oracle»ù´¡½Ì³Ì
ÍøÉÏÏÂÔØ
http://www.ibook8.com/book/oracl ......
ÎÒÊÇѧ SQL Server µÄÏÖÔÚÏëѧOracle ÇëÎʸ÷λÓÐûÓкõÄÊé½éÉÜһϠлÁË
¾«Í¨Oracle10g SQLºÍPL\SQL
Oracle+SQL±Ø±¸²Î¿¼
Oracle10GÈëÃÅÓëʵ¼ù
oracle»ù´¡½Ì³Ì
ÍøÉÏÏÂÔØ http://www.ibook8.com/book/oracle.htm
......
°²×°ºóÉèÖÃÁËÊÖ¶¯Æô¶¯¡£½á¹ûÆô¶¯µÄʱºòÌáʾ²»ÄÜÆô¶¯ORACLEdbconsoleORCL,´íÎó´úÂë2
¿´ÁËÍøÉϵÄһЩ½â¾ö°ì·¨£¬½á¹ûÔÚÎÒ»ú×ÓÉÏʵÑé½á¹ûÈçÏ£º
Çë´óÏÀÖ¸½Ì¡£
ÌáʾÖÐÏÔʾ¼àÌý³ÌÐòδÆô¶¯£¬µ«ÎÒ´Ó·þÎñÀï¿´£¬LISTNERÒѾÆô¶¯Á˰¡~·Ç³£²»½â¡£
¸øLZ¶¥ÆðÀ´ÏÈ£¬Ï£ÍûÄãµÄÎÊÌ ......
ÎÒÔÚ¿´oracle ocpµÄʱºò¿´¼ûÀïÃæÓÐ˵labsÎļþ¼ÐÏÂÃæÓкܶàµÄ sqlÎļþ¿ÉÒÔÓÃÀ´°ïÖúÄ£Äâoracle³öµÄÒ»ÏÂ×´¿ö£¬µ«ÊÇΪʲôÎÒµÄoracleÖÐûÓУ¿Çë¸ßÊÖÖ¸½Ì¡£
°æ±¾²»Í¬£¬Ä¿Â¼²»Ò»Ñù¡£
ÓеÄÒ²ÐíÊÇÄãûװij¸ö×é¼þ¡£
ÄÇÎÒÒªÏÂÒ»¸ölabsÎļþ£¿¸Ãµ½ÄÄÀïÈ¥ÕÒÄØ£¿
......
ÎÒÏÂÔØÁ˼¸¸ö¹ØÓÚoracle ²éѯÓÅ»¯µÄ ·½·¨£¬ ÎÄÖÐÌáµ½ oracle ²é±í´Ó ÓÒÖÂ×ó£¬whereÖ´ÐÐÌõ¼þ ˳ÐòÒ²ÊÇ ´ÓÓÒµ½×ö
ÀýÈç
±í TAB1 16,384 Ìõ¼Ç¼
±í TAB2 1 Ìõ¼Ç¼
select count(*) from tab1,tab2 Ö´ÐÐʱ¼ä0.96Ãë
sel ......
fedoraÏÂÃæ°²×°oracle xeµÄÎÊÌ⣿
ÎÒ²»ÖªµÀÄÄÀïÅä´íÁË£¬Æô¶¯oracleµÄʱºò³ö´í£º
Ç뿴ͼ£º
¢Ù
ÎÒÕÕ×ÅÍøÉÏ×°µÄ£¬×°ÍêÁËÖØÆôϵͳ£¬µÇ½±ä³ÉÏÂÃæÕâÑù£º
¢Ú
ÎÒÓÃrootµÇ½£¬Æô¶¯oracleʱºò£¬¾Í±¨ÏÂÃæµÄ´í£º
¢Û
ÎÒÓÃÃüÁîÐÐÆô¶¯£º
ÇóÕâÀïµÄ¸ßÊÖ°ïÎÒһϣº
......