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
Ïà¹ØÎĵµ£º
declare
begin
--SQLÓï¾ä
--Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
--¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
--select Óï¾ä
<1>±ØÐë´øÓÐinto×Ó¾ä
&n ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ ......
OracleÊý¾Ý¿â½ø³Ì¸ÅÊö£º
Database buffer cacheÖ÷ÒªÓÃÓÚ´æ´¢Êý¾ÝÎļþÖеÄÊý¾Ý¿é
Êý¾Ý¿â¸ßËÙ»º´æµÄÊý¾Ý¿éÊǸßËÙ»º´æÓëÊý¾ÝÎļþ½øÐÐÐÅÏ¢½»»»µÄ»ù±¾µ¥Î»¡£ÔÚOracleÊý¾Ý¿â8iÒÔǰ,Êý¾Ý¿é´óСֻÓÐÒ»ÖÖ,¶øOracleÊý¾Ý¿â9iÒÔºóÖ§³Ö2K,4K,8KB,16KB¼°32KBÎåÖÖ¡£
ÓÃÃüÁîSQL>SHOW PARAMETER DB¿ÉÒÔÏÔʾµ±Ç°Êý¾Ý¿âµÄBUFF ......
Àý£º
create user his identified by his default tablespace users temporary tablespace temp;
grant connect,resource,dba to his;
create tablespace his
logging
datafile 'd:\oracle\product\10.2.0\oradata\zjxsh\his.ora' size 100M extent
management local segment space management auto;
exp his/ny@ny ......
1¡¢ÅäÖÃhibernate£º
1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ
org.springframework.orm.hibernate3.support.BlobByteArray ......