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

Oracle»ù´¡Ñ§Ï°±Ê¼Ç

1.sqlplus-----¿ªÆô·þÎñ
2.ÊäÈëÓû§ÃûºÍÃÜÂ루ĬÈÏ3¸öÓû§,×¢Ò⣬ÃÜÂëÊÇ¿ÉÒÔÐ޸ĵģºsystem/manager;scott/tiger;sys/change_on_install£©£¬Á¬½ÓÊý¿â¡£
3.´´½¨±í¿Õ¼ä£º
 create tablespace ±í¿Õ¼äÂß¼­Ãû datafile '±í¿Õ¼äÎļþµÄÎïÀíÂß¼­'
 size Îļþ´óС£¨È磺10m£© autoextend ÊÇ·ñ×Ô¶¯Ôö³¤Îļþ´óС£¨on/off£©;
4.´´½¨Óû§£ºcreate user Óû§Ãû identified by ÃÜÂ룻
5.Óû§ÊÚȨ£ºgrant connect to Óû§Ãû  --------±íʾÊÚÓèÓû§Á¬½ÓµÄȨÏÞ
     grant dba to Óû§Ãû  ------±íʾÊÚÓè¹ÜÀíÔ±µÄȨÏÞ
     grant resource to Óû§Ãû -----±íʾ´´½¨Ò»¸öȨÏÞ¶ÔÏó
     --Á¬½Ó
     conn admin/admin;
     --Á¬½Óµ±Ç°Óû§
     conn yangjian/yangjian;
     --ÐÞ¸ÄÓû§ÃÜÂë
     alter user system identified by system;
     --ɾ³ýÓû§(cascadeɾ³ýģʽ¶ÔÏó)
     drop user admin cascade;
6.exit  -----Í˳öÁ¬½Ó
7.´´½¨±í£º
 create table ±íÃ÷
 £¨
  sid varchar2(20),    --varchar2±íʾ¶¯Ì¬µÄ×Ö·ûÀàÐÍ
  sage int   ----Êý×ÖÀàÐÍ
 £©;
 --ɾ³ý±í¿Õ¼ä
 Drop tablespace spac
 --Ð޸ıí
 --1.Ϊָ¶¨µÄ±íÌí¼ÓÒ»ÁÐ
 alter table student add(score varchar2(3))
 --2.ÐÞ¸ÄÖ¸¶¨ÁÐ
 alter table student modify(score number(3,1))
 --3.ɾ³ýÖ¸¶¨µÄÁÐ
 alter table student drop column score
 --4.²é¿´Ö¸¶¨±íµÄ½á¹¹
 desc student
 --ɾ³ý±í
 --1.ֻɾ³ý±íÖеÄËùÓÐÊý¾Ý£¬±£Áô±íµÄ½á¹¹
 truncate table student
 delete student;
 --2.ɾ³ýÕû¸ö±í£¬°üÀ¨±íµÄÕû¸ö½á¹¹
 drop table student
8.show user   ------ÏÔʾµ±Ç°µÇ½Óû§Ãû
9.´´½¨Ò»¸öÐòÁУº
 create sequence  ÐòÁÐÃû start with 1 increment by 2 minvalue 1 maxvalue 2000
 cycle/uncycle;     -----±íʾ¸ÃÐòÁдÓ1¿ªÊ¼£¬×ÔÔö2£¬×îСֵ1£¬×î´óÖµ2000£¬cycle±íʾµ½´ï×î´óÖµºó    


Ïà¹ØÎĵµ£º

OracleÈÕÆÚº¯Êý next_day

ÔÚOracleÊÇÌṩÁËnext_dayÇóÖ¸¶¨ÈÕÆÚµÄÏÂÒ»¸öÈÕÆÚ.
Óï·¨ : next_day( date, weekday )
date is used to find the next weekday.
weekday is a day of the week (ie: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
¿ÉÓÃÓÚ:
Oracle 9i, Oracle 10g, Oracle 11g
For example:
next_day('01- ......

´«ÖDz¥¿Í——Êý¾Ý¿âÖ®ORACLE£¨Ò»£©


Ò» Oracle¹«Ë¾¼ò½é 
OracleÊÇÒóÐæ³öÍÁµÄ¼×¹ÇÎÄ(oracle bone inscriptions)µÄÓ¢ÎÄ·­ÒëµÄµÚÒ»¸öµ¥´Ê
Oracle¹«Ë¾ÊÇÈ«Çò×î´óµÄÐÅÏ¢¹ÜÀíÈí¼þ¼°·þÎñ¹©Ó¦ÉÌ£¬³ÉÁ¢ÓÚ1977Ä꣬×ܲ¿Î»ÓÚÃÀ¹ú¼ÓÖÝ Redwood shore
Oracle¹«Ë¾ÒòÆä¸´ÔӵĹØÏµÊý¾Ý¿â²úÆ·¶øÎÅÃû¡£OracleµÄ¹ØÏµÊý¾Ý¿âÊÇÊÀ½çµÚÒ»¸öÖ§³ÖSQLÓïÑÔµÄÊý¾Ý¿â
OracleÔÚ³¬¹ý ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

1.¾ø¶ÔÖµ 
S:select abs(-1) value
O:select abs(-1)  value from dual
2.È¡Õû(´ó) 
S:select ceiling(-1.001) value  
O:select ceil(-1.001)  value from dual
3.È¡Õû£¨Ð¡£© 
S:select floor(-1.001) value  
O:select floor(-1.001)  value from dual
4.È ......

ORACLE´ø²ÎÈ«Á¬½Ó

    
  select * from (
  select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME
  from COM_WHOLE_INFO cw2,SYS_OPERATOR so, SYS_PUBLICARGUMENT sp1, SYS_PUBLICARGUMEN ......

¡¾×ª¡¿ ORACLE ·ÖÇø±í PARTITION table

ORACLE ·ÖÇø±í PARTITION table
http://blog.chinaunix.net/u/6889/showart_315897.html
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ