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

oracle %type

1¡¢Ê¹ÓÃ%TYPE
ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿
DECLARE
v_FirstName VARCHAR2(20);
µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ˻ᷢÉúʲô£¨±ÈÈç˵±í¸Ä±äÁË£¬first_nameÏÖÔÚµÄÀàÐͱäΪVARCHAR2(25)£©£¿ÄǾͻᵼÖÂËù ÓÐʹÓÃÕâ¸öÁеÄPL/SQL´úÂ붼±ØÐë½øÐÐÐ޸ġ£Èç¹ûÄãÓкܶàµÄPL/SQL´úÂ룬ÕâÖÖ´¦Àí¿ÉÄÜÊÇÊ®·ÖºÄʱºÍÈÝÒ׳ö´íµÄ¡£
Õâʱ£¬Äã¿ÉÒÔʹÓÔ%TYPE”ÊôÐÔ¶ø²»Êǽ«±äÁ¿ÀàÐÍÓ²ÐÔ±àÂë¡£
ÀýÈ磺
DECLARE
v_FirstName students.first_name%TYPE;
ͨ¹ýʹÓÃ%TYPE,v_FirstName±äÁ¿½«Í¬students±íµÄfirst_nameÁеÄÀàÐÍÏàͬ£¨¿ÉÒÔÀí½âΪ½«Á½Õ߰ÆðÀ´£©¡£
ÿ´ÎÄäÃû¿é»òÃüÃû¿éÔËÐиÃÓï¾ä¿éÒÔ¼°±àÒë´æ´¢¶ÔÏ󣨹ý³Ì¡¢º¯Êý¡¢°ü¡¢¶ÔÏóÀàºÍ´¥·¢Æ÷£©Ê±£¬¾Í»áÈ·¶¨¸ÃÀàÐÍ¡£
ʹÓÃ%TYPEÊǷdz£ºÃµÄ±à³Ì·ç¸ñ£¬ÒòΪËüʹµÃPL/SQL¸ü¼ÓÁé»î£¬¸ü¼ÓÊÊÓ¦ÓÚ¶ÔÊý¾Ý¿â¶¨ÒåµÄ¸üС£
ÀýÈ磺
declare
v_id hr.jobs.job_id%type;
v_title hr.jobs.job_title%type;
begin
select job_id,job_title into v_id,v_title
from hr.jobs
where job_id ='&aa';
dbms_output.put_line('ÐòºÅ'||v_id );
dbms_output.put_line('Ãû³Æ'||v_title);
end;
Ö´ÐУ¬ÎÒÃÇÊäÈëaa±äÁ¿µÄÖµ£ºAD_VP
Êä³ö½á¹ûΪ£º
ÐòºÅAD_VP
Ãû³ÆAdministration Vice President
2 ʹÓÃ%ROWTYPE  (Ï൱ÓÚ¶¨ÒåÒ»¸östruct À´½øÐдæ·Å£¬ÒÔ¶ÔÏóÀ´¿´¶ÔÊý¾Ý£©
ÔÚPL/SQLÖн«Ò»¸ö¼Ç¼ÉùÃ÷Ϊ¾ßÓÐÏàͬÀàÐ͵ÄÊý¾Ý¿âÐеÄ×÷·¨ÊǺܳ£¼ûµÄ¡£PL/SQLÌṩÁË%ROWTYPEÔËËã·û£¬Ê¹µÃÕâÑùµÄ²Ù×÷¸üΪ·½±ã¡£
ÀýÈ磺
DECLARE
v_StudentRecord students%ROWTYPE;
½«¶¨ÒåÒ»¸ö¼Ç¼£¬¸Ã¼Ç¼ÖеÄ×ֶν«Óëstudents±íÖеÄÁÐÏà¶ÔÓ¦¡£
ÀýÈ磺
declare
v_jobs hr.jobs%rowtype;
begin
select * into v_jobs
from hr.jobs
where job_id ='&aa';
dbms_output.put_line('ÐòºÅ'||v_jobs.job_id );
dbms_output.put_line('Ãû³Æ'||v_jobs.job_title);
end;
Ö´ÐУ¬ÎÒÃÇÊäÈëaa±äÁ¿µÄÖµ£ºAD_VP
Êä³ö½á¹ûΪ£º
ÐòºÅAD_VP
Ãû³ÆAdministration Vice President
×÷Õߣºtshfang
À´Ô´: ÄàÅßÎÄÕÂд×÷ http://www.nipei.com Ô­ÎĵØÖ·£º http://www.nipei.com/article/2384


Ïà¹ØÎĵµ£º

½øÐÐoracleµÄÀ䱸·Ý

1¡¢À䱸·Ý±ØÐ뽫Êý¾Ý¿â·þÎñÆ÷Í£Ö¹£¬²»È»»Ö¸´µÄʱºòÎÞ·¨»Ö¸´
Í£Ö¹·þÎñÆ÷µÄÃüÁ
ÔÚsqlplusϵǽsqlplus£ºsqlplus "/as sysdba"
Í£Ö¹oracle·þÎñ£º shutdown immediate;£¨´ËÃüÁîµÈ´ýÊÂÎñÖ´ÐÐÍê±ÏºóÔٹرգ©
ÊÇÔÚ²»ÐÐÖ±½ÓÇ¿ÐÐÖÕÖ¹:shutdown abort;£¨´ËÃüÁîÖ±½Ó¹Ø±ÕʵÀý·þÎñ£©
¹Ø±Õlistener£º
linuxÃüÁlsnrctl
È»ºóÍ ......

ORACLE ÖÐINºÍEXISTSµÄÇø±ð

Ô­ÎĵØÖ·£ºhttp://www.cnblogs.com/yf520gn/archive/2009/01/12/1374359.html
EXISTSµÄÖ´ÐÐÁ÷³Ì     
select * from t1 where exists ( select null from t2 where y = x )
¿ÉÒÔÀí½âΪ:
  for x in ( select * from t1 )
  loop
      if ( exists ( select null from ......

oracle online documentation

oracle 9i online documentation:
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
oracle 10g online documentation:
http://www.oracle.com/pls/db102/homepage
oracle 11g online documentation:
http://www.oracle.com/pls/db111/homepage ......

Oracle 11g ÐÂÌØÐÔ¼ò½é

 
Oracle 11gÓÚ2007Äê7ÔÂ11ÈÕÃÀ¹ú¶«²¿Ê±¼ä11ʱ£¨±±¾©Ê±¼ä11ÈÕ22ʱ£©Õýʽ·¢²¼£¬11gÊǼ׹ÇÎĹ«Ë¾30ÄêÀ´·¢²¼µÄ×îÖØÒªµÄÊý¾Ý¿â°æ±¾£¬¸ù¾ÝÓû§µÄÐèÇóʵÏÖÁËÐÅÏ¢ÉúÃüÖÜÆÚ¹ÜÀí£¨Information Lifecycle Management£©µÈ¶àÏС£ 
 
Ò»£®ÐÂÌØÐÔÌá¸Ù
 
1.Êý¾Ý¿â¹ÜÀí²¿·Ö
¡ôÊý¾Ý¿âÖØÑÝ(Database Replay)&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ