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

Oracle´æ´¢¹ý³ÌµÄÖ´ÐÐ

declare
msg varchar(1000);    --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg);   --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg);   --Êä³ö±äÁ¿
end;


Ïà¹ØÎĵµ£º

Oracleѧϰ±Ê¼Çժ¼1

 1.create alter insert update selectµÈ
ÈçºÎ½¨±í
   ѧÉú±ístudent
        create table student( --ѧÉú±í
           xh number(4), --ѧºÅ
           ......

Oracle SQL*PlusµÄ»·¾³ÅäÖ㨸ü¸ÄÐÐ¿í£©

µ±ÎÒÃÇÓÃoracleµÄSQL*Plus¹¤¾ßÊäÈësqlÓï¾äµÄʱºò£¬SQL*PlusµÄĬÈÏÉèÖÃ×ÜÓÐЩ²»ºÏÀíµÄµØ·½£¬´ËʱÎÒÃÇͨ¹ýÒÔÏÂһЩ·½·¨¸Ä½ø£º
1¡¢¿ÉÒÔÔËÓÃSQL*Plus×ÔÉíһЩÓï¾ä¸Ä±ä»·¾³²ÎÊý¡£
     SQL>  set linesize 900 ;   /* ¸ü¸ÄÏÔʾµÄ¿í¶È, ÉèÖóÉ900ºó, Ò»ÐÐÊý¾Ý¾Í²»»á·ÖÁ½ÐÐÏÔʾÁË */
&nb ......

ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ

ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓᣡ¡¡¡ ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ ......

oracle Ë÷Òý

2009-07-16 10:59
Ë÷Òý´´½¨²ßÂÔ
1.µ¼ÈëÊý¾ÝºóÔÙ´´½¨Ë÷Òý
2.²»ÐèҪΪºÜСµÄ±í´´½¨Ë÷Òý
3.¶ÔÓÚÈ¡Öµ·¶Î§ºÜСµÄ×ֶΣ¨±ÈÈçÐÔ±ð×ֶΣ©Ó¦µ±½¨Á¢Î»Í¼Ë÷Òý
4.ÏÞÖƱíÖеÄË÷ÒýµÄÊýÄ¿
5.ΪË÷ÒýÉèÖúÏÊʵÄPCTFREEÖµ
6.´æ´¢Ë÷ÒýµÄ±í¿Õ¼ä×îºÃµ¥¶ÀÉ趨
´´½¨²»Î¨Ò»Ë÷Òý
create index emp_ename on employees(ename)
table ......

oracle °ü

 package¾ÍÊÇÓÃÀ´·â×°¹ý³Ì£¬º¯ÊýÓõġ£
Ò»¸öpackage¿ÉÒÔ´æ·Å¶à¸ö¹ý³Ì£¬º¯Êý¡£
µ÷ÓÃÊÇ£º
°üÃû.¹ý³ÌÃû1
°üÃû.¹ý³ÌÃû2
http://hank4ever.javaeye.com/blog/472336
°ü (package)
¡¡¡¡(1)°üµÄÒâÒå
¡¡¡¡pl/sqlΪÁËÂú×ã³ÌÐòÄ£¿é»¯µÄÐèÒª,³ýÁË¿é(block)ºÍ×Ó³ÌÐò½á¹¹Íâ,»¹ÒýÈëÁË°üµÄ¹¹Ôì¡£
¡¡¡¡°üÊÇÒ»ÖÖÊý¾Ý¿â¶ÔÏó,½«Â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ