select * from SCOTT.TEACHER teacher3_ where teacher3_.POST='¹ÜÀíÔ± ' or teacher3_.DEPARTID='004' and teacher3_.POST='ϵ½ÌÑ§ÃØÊé ' or teacher3_.POST='ϵÖ÷ÈÎ &am ......
OracleÊDz»ÊDz»Ö§³ÖÒÔϵÄд·¨£º
1. select * from emp where ename like '[ABC]%';
2. select * from emp where ename like '[A-D]%';
3. select * from emp where ename like '%[%]%';
......
drop table test_olap;
-- Create table
create table TEST_OLAP
(
CLASS NUMBER(1),
NAME VARCHAR2(100),
SCORE NUMBER(4,1) default 0
);
delete from test_olap;
insert into test_olap (class, name,score)values(2, 'b2', 34);
insert into tes ......
win7ÏÂÈçºÎ°²×°oracle·þÎñ¶Ë°¡£¿10G²»¿ÉÒÔÂð£¿ÎÒÏÖÔÚû°²×°³É¹¦¹ýÄÄλ´ïÈËÖ¸µãϰ¡Ð»À²£¡
win7ÊÇ32λµÄ»¹ÊÇ64λµÄ£¿ÍøÉÏ˵10G¿ÉÒԵģ¬9iºÃÏñ²»ÐС£
ÓÐÎÊÌâ÷á
´íÎóÌáʾ£¿
ÖªµÀ2003ÉÏ×°¹ý£¬ÆäËûµÄ¶¼Ã»ÓÐÊÔ¹ý£¡
10g ¿ÉÒÔ ÎÒ×°¹ý³É¹¦ÁË ×°Í껹µÃϸö¿Í»§¶Ë..ÄÇÍøÒ³¿Í»§¶ËTM.D˵ÊäÈë±¾µØÕË»§ÃÜÂë
´òÍê´íÎó..
......
ÈçÌâÈçÌâÈçÌâлл¸÷λ´ó´óÁË£¬ÕÒÁ˺ܾö¼Ã»ÕÒµ½½â¾ö°ì·¨~~~~(>_ <)~~~~
Ö±½Óµã»÷°²×°ß£¬ÓÐʲô´íÎó£¿
ÒýÓÃ
Ö±½Óµã»÷°²×°ß£¬ÓÐʲô´íÎó£¿
ÄãÖ±½Ó°²×°¾Í¿ÉÒÔÁËÂð£¿ÎÒµÄÌáʾ²»¼æÈݰ¡~~~~(>_ <)~~~~
ÎÒ°²×°µÄ11G¡£µÍ°æ±¾µÄûÊÔ¹ý¡£11gÓÐÌáʾϵͳ²»¼æÈÝ¡£µ«ÊÇÊÖ¹¤È·ÈϾͿÉÒÔÁË¡£
Ö± ......
RT...........
±¾È˳õѧ .....Íû´ó¼Ò¸ø¸ö½¨Òé
Ϊɶ²»¿ÉÒÔ£¿³õѧÖ÷ÒªÊÇѧһЩ³£Óûù±¾¹¦ÄÜ¡£
¸ß¼¶¹¦Äܵϰ°æ±¾²»Í¬»áÓвî±ð£¬»ù±¾¹¦ÄÜÓ¦¸Ã8.0.5¿ªÊ¼¾ÍÒѾ±È½ÏÈ«ÁË¡£
ÄÇ 10g µÄÄØ£¿ÔõôÑù£¿
ÎÒ¾õµÃ»¹ÊÇ10gºÃµã£¬ÏÖÔڱϾ¹11g¶¼³öÀ´ÁË£¬µ«ÊǺܶ๫˾»¹ÊÇÓõÄ10g£¬9i¸Ð¾õÓеã¾ÃÔ¶ÁË¡£
¸Ð¾õûÓжà´óÇø±ð,³ýÁËһЩ¸ ......