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

Oracleѧϰ±Ê¼Çժ¼1

 1.create alter insert update selectµÈ
ÈçºÎ½¨±í
   ѧÉú±ístudent
        create table student( --ѧÉú±í
           xh number(4), --ѧºÅ
           xm varchar2(10), --ÐÕÃû
           sex char(2), --ÐÔ±ð
           birthday date, --ÈÕÆÚ
           sal number(7,2) --½±Ñ§½ð
        );
   °à¼¶class
       create table class( --°à¼¶±í
          classid number(2), --°à¼¶±àºÅ
          cname varchar2(20) --°à¼¶Ãû×Ö
       );
  Ìí¼Ó×Ö¶Î(ѧÉúËùÔڰ༶classid)
      alter table student add (classid number(2));
  ÐÞ¸Ä×ֶεij¤¶È
      alter table student modify (xm varchar2(12)) ;
  ÐÞ¸Ä×ֶεÄÀàÐÍ(²»ÄÜÓмǼµÄ)
      alter table student modify (xh varchar2(5));
  ɾ³ýÒ»¸ö×Ö¶Î
      alter table student drop column sal;
  ɾ³ý±í
      drop table student;
  ±íµÄÃû×ÖÐÞ¸Ä
      rename student to stu;
  ×Ö¶ÎÈçºÎ¸ÄÃû×Ö
      --ÏÈɾ³ý
      a)alter table student drop column sal;        
      --ÔÙÌí¼Ó
      b)alter table student add (salary number(7,2));
ÈçºÎ²åÈëÊý¾Ý
  ²åÈëÊý¾Ý insertÓï¾ä
      ËùÓÐ×ֶζ¼²åÈë
       insert into student values ('A001','ÕÅÈý','ÄÐ','01-5ÔÂ-05',10);
 &n


Ïà¹ØÎĵµ£º

OracleµÄÌåϵ

 oracleµÄÌåϵºÜÅÓ´ó£¬ÒªÑ§Ï°Ëü£¬Ê×ÏÈÒªÁ˽âoracleµÄ¿ò¼Ü¡£ÔÚÕâÀ¼òÒªµÄ½²Ò»ÏÂoracleµÄ¼Ü¹¹£¬ÈóõѧÕß¶ÔoracleÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
¡¡¡¡1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£©
¡¡¡¡¿ØÖÆÎļþ£º°üº¬Î¬»¤ºÍÑéÖ¤Êý¾Ý¿âÍêÕûÐԵıØÒªÐÅÏ¢¡¢ÀýÈ磬¿ØÖÆÎļþÓÃÓÚʶ±ðÊý¾ÝÎļ ......

oracle¸ü¸Ä¹éµµÂ·¾¶

1.¸ü¸Ä¹éµµÂ·¾¶
ÔÚORACLE10GÖУ¬Ä¬ÈϵĹ鵵·¾¶Îª$ORACLE_BASE/flash_recovery_area¡£¶ÔÓÚÕâ¸ö·¾¶£¬
ORACLEÓÐÒ»¸öÏÞÖÆ£¬¾ÍÊÇĬÈÏÖ»ÄÜÓÐ2GµÄ¿Õ¼ä¸ø¹éµµÈÕ־ʹÓ㬿ÉÒÔʹÓÃÏÂÃæÁ½¸öSQLÓï¾äÈ¥²é¿´ËüµÄÏÞÖÆ
1. select * from v$recovery_file_dest;
sql >show parameter db_recovery_file_dest(Õâ¸ö¸üÓѺÃÖ±¹ÛһЩ)
µ± ......

Javaµ÷ÓÃOracleÊý¾Ý¿âµÄ·ÖÒ³´æ´¢¹ý³Ì

 ×î½üÏîÄ¿½ø¶È±È½Ï»ºÂý£¬³õ²½Ñо¿ÁËÒ»ÏÂOracleµÄ´æ´¢¹ý³Ì£¬½«´úÂëÌù³öÀ´¡£
 Ê×ÏÈÏÈÌù³öÀ´OracleµÄ·ÖÒ³·ÖÒ³´æ´¢¹ý³Ì´úÂë°É¡£
 1.ÕâÊǰüµÄ´úÂë
 create or replace package DB_Oper is
  -- Author  : LIUBING
  -- Created : 2009-10-28 15:01:30
  -- Purpose : ²âÊÔOracleµ ......

Oracle JOBʱ¼ä¼ä¸ô²Î¿¼

   ×î½ü×öÁËÒ»¸öϵͳ×Ô¶¯³é¼ìµÄ¶«¶«£¬OracleÖд´½¨µÄJob,»áÔÚ×Ô¼ºÉ趨µÄʱ¼ä×Ô¶¯ÔËÐд洢¹ý³Ì¡£ÏÂÃæÎª×î½ü×ܽáµÄ¶«¶«
¼ÙÉèÄãµÄ´æ´¢¹ý³ÌÃûΪPROC_RAIN_JM
ÔÙдһ¸ö´æ´¢¹ý³ÌÃûΪPROC_JOB_RAIN_JM
ÄÚÈÝÊÇ£º
///////////////////////////////////////////////////////////////////
Create Or Replace Procedure ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ