OracleµÄ³õʼ»¯²ÎÊýÎļþ
oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£
pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀý²ÎÊýµÄ¶¯Ì¬Ð޸쬵«²»ÄÜÖ±½ÓÐ޸ģ¬Ö±½ÓÐ޸ĻáËð»µspfile²ÎÊýÎļþ£¬´Ó¶øÒýÆðʵÀýÆô¶¯Ê§°Ü¡£
pfileÎļþµÄĬÈÏÃû³ÆÎª init<SID>.ora
spfileÎļþµÄĬÈÏÃû³ÆÎª spfile<SID>.ora
Á©ÎļþµÄλÖÃÔÚ <$oracle_home>/product/10.2.1/db_1/dbs/
³õʼ»¯²ÎÊýÎļþµÄÓÅÏȼ¶Îª spfile<sid>.ora ----> spfile.ora ----> init<SID>.ora
¿ÉÒÔʹÓà show parameter spfile ²é¿´µ±Ç°¿´ÕýÔÚʹÓõijõʼ»¯²ÎÊýÎļþÊÇÄĸö
spfileÓëpfileµÄ»¥Ïàͬ²½
create pfile from spfile »ò
create pfile = <pfilename> from spfile = <spfilename>
create spfile from pfile »ò
create spfile = <spfilename> from pfile = <pfilename>
Ö»ÄÜÔÚÊý¾Ý¿â¹Ø±ÕµÄÇé¿öϽøÐÐcreate spfile²Ù×÷£¬ÇÒÎļþÃû²»ÄÜÓëÕýÔÚʹÓõÄÊý¾Ý¿âµÄspfileÏàͬ£¬·ñÔò»á´´½¨Ê§°Ü¡£
Ïà¹ØÎĵµ£º
1¡¢ÅäÖÃhibernate£º
1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ
org.springframework.orm.hibernate3.support.BlobByteArray ......
µ¥Ðк¯Êý ·µ»ØÖµÖ»ÓÐÒ»¸ö
·Ö×麯Êý ·µ»ØÖµÊǶàÌõ¼Ç¼
group by
sum
avg   ......
½¨Á¢±íÈçÏÂ:
ѧÉú»ù±¾ÐÅÏ¢±í
CREATE Student(
[Studentid][Int]IDENTITY(1,1)NOT NULL primary key,--Ö÷¼ü
[StudentName][char]NOT NULL
)
¿Î³ÌÐÅÏ¢±í
CREATE Subject(
[SubjectID][char]NOT NULL primary key, --Ö÷¼ü
[SubjectName][char]NOT NULL
)
³ ......
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
¾ÙÀý˵Ã÷£º
ÀýÈç±í£ºstudent(ѧÉú)±í£¬±í½á¹¹Îª£º
ID¡¡¡¡¡¡ char(6)¡¡¡¡¡¡¡¡¡¡ --ѧºÅ
name¡¡¡¡¡¡¡¡VA ......