oracle plsql ´æ´¢¹ý³Ì³£ÓÃÀý×Ó
Author:qinyangzhao
describe:PL/SQL¼Ç¼¼Ç¼ (type is record)
*********************************************************/
set serveroutput on--´ò¿ªÏÔʾģʽ
declare
type cust_record_type is record(--¶¨Òå¼Ç¼ÀàÐÍ
name customer.name%type,--ÉùÃ÷±êÁ¿±äÁ¿
total ord.total%type--ÉùÃ÷¼Ç¼±äÁ¿
);
cust_record cust_record_type;
begin
select a.name ,b.total ,into cust_record
from customer a ,ord b
where a.customer_id=b.customer_id and b.ord_id=&id;
dbms_output.put_line('¿Í»§Ãû'||cust_record.name);
dbms_output.put_line('¶©µ¥×ܶî:'||cust_record.total);
end;
/*********************************************************
 
Ïà¹ØÎĵµ£º
ÔÚ¿ª·¢¹ý³Ì³öÏÖÕâôһ¸öÎÊÌ⣺
±ÈÈ磺һ¸ö×Ö¶Îcontent ÀàÐÍCLOB£¬ÕâÆäÖдæµÄÓпÉÄܸ´ÖÆÕ³Ìù¹ýÀ´µÄword excel htmlÖеÄÄÚÈÝ£¬ÓÃjava½«ÕâЩÄÚÈÝ´æÈ룬´æÈëºóÓÐÌØÊâµÄ·ûºÅ ±ÈÈç»Ø³µ»»Ðеȡ£ÄÇô²»ÄÜÕý³£Õ¹Ê¾µÄÊý¾Ý¡£
½â¾ö·½°¸£º
´æÈëÊý¾ÝµÄÊǽ«Õâ¸öÊý¾ÝcontentdataÔÚjsÖнøÐÐ
......
OracleΪRDBMSÌṩÁ˶àÖÖµÄÕï¶Ï¹¤¾ß£¬Õï¶Ïʼþ(Event)ÊÇÆäÖÐÒ»ÖÖ³£ÓᢺÃÓõķ½·¨£¬ËüʹDBA¿ÉÒÔ·½±ãµÄת´¢Êý¾Ý¿â¸÷Öֽṹ¼°¸ú×ÙÌض¨Ê¼þµÄ·¢Éú.
Ò»¡¢EventµÄͨ³£¸ñʽ¼°·ÖÀà
1¡¢ ͨ³£¸ñʽÈçÏ£º
EVENT="<ʼþÃû³Æ><¶¯×÷><¸ú×ÙÏîÄ¿><·¶Î§ÏÞ¶¨>"
2¡¢ Event·ÖÀà
Õï ......
OracleÊý¾Ý¿â·ÖÇø±í²Ù×÷·½·¨
(2009-10-19 16:20:45)
±êÇ©£º
ÔÓ̸
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬ÄÜ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÖÜÏê½éÉÜÁË·ÖÇø±íµÄʹÓá£
¡¡¡¡ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£ÄÜ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁÄܵ½TB¼¶¡£ËäÈ»´æ´¢ ......
Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......
exp document/document2009@document owner=document rows=y compress=y buffer=65536 feedback=100000 file=D:\document.dmp log=D:\document.log
exp whd/whd2009@whddb owner=whd rows=y compress=y buffer=65536 feedback=100000 file=D:\whd.dmp log=D:\whd.log
imp document/document2009@document fromuser=docume ......