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ÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
¡¡¡¡1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£©
¡¡¡¡¿ØÖÆÎļþ£º°üº¬Î¬»¤ºÍÑéÖ¤Êý¾Ý¿âÍêÕûÐԵıØÒªÐÅÏ¢¡¢ÀýÈ磬¿ØÖÆÎļþÓÃÓÚʶ±ðÊý¾ÝÎļ ......
˵µ½Èí½âÎö£¨soft prase£©ºÍÓ²½âÎö£¨hard prase£©£¬¾Í²»Äܲ»ËµÒ»ÏÂOracle¶ÔsqlµÄ´¦Àí¹ý³Ì¡£µ±Äã·¢³öÒ»ÌõsqlÓï¾ä½»¸¶Oracle£¬ÔÚÖ´ÐкͻñÈ¡½á¹ûǰ£¬Oracle¶Ô´Ësql½«½øÐм¸¸ö²½ÖèµÄ´¦Àí¹ý³Ì£º
1¡¢Óï·¨¼ì²é£¨syntax check£©
¼ì²é´ËsqlµÄƴдÊÇ·ñÓï ......
ΪÁËÈ·¶¨±í¿Õ¼äÖаüº¬ÄÇЩÄÚÈÝ£¬ÔËÐУº
select owner,segment_name,segment_type
from dba_segments
where tablespace_name='<name of tablespace>'
²éѯ±í¿Õ¼ä°üº¬¶àÉÙÊý¾ÝÎļþ¡£
select file_name, tablespace_name
from dba_data_files
where tablespace_name ='<name of t ......
1¡¢ÅäÖÃhibernate£º
1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ
org.springframework.orm.hibernate3.support.BlobByteArray ......
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂÎª×ªÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......