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

±±´óÇàÄñoracleѧϰ±Ê¼Ç29 30

oracleÄÚÖóÌÐò°ü
STANDARDºÍDBMS_STANDARD ¶¨ÒåºÍÀ©Õ¹PL/SQLÓïÑÔ»·¾³
DBMS_ALERT Ö§³ÖÊý¾Ý¿âʼþµÄÒ첽֪ͨ
DBMS_APPLICATION_INFO ÔÊÐíΪ¸ú×ÙÄ¿µÄ¶ø×¢²áÓ¦ÓóÌÐò
DBMS_AQ&DBMS_AQADM ¹ÜÀíoracle advanced queuingÑ¡¼þ
DBMS_DEFER¡¢DBMS_DEFER_SYSºÍDBMS_DEFER_QUERY ÔÊÐí¹¹½¨ºÍ¹ÜÀíÑÓ³ÙµÄÔ¶³Ì¹ý³Ìµ÷ÓÃ
DBMS_DDL ijЩDDLÃüÁîµÄpl/sqlµÈЧÏî
CALENDAR ÌṩÈÕÀúά»¤¹¦ÄÜ
DBMS_DESCRIBE ÃèÊö´æ´¢×Ó³ÌÐò
DBMS_LOB ²Ù×ÝLOB¶ÔÏó
DBMS_LOG Ìṩ¶Ô Oracle LOBÊý¾ÝÀàÐͽøÐвÙ×÷µÄ¹¦ÄÜ
DBMS_LOCK Óû§¶¨ÒåµÄËø
DBMS_OUTPUT ´¦ÀíPL/SQL ¿éºÍ×Ó³ÌÐòÊä³öµ÷ÊÔÐÅÏ¢
DBMS_SESSION ÌṩALTER SESSION ÃüÁîµÄPL/SQLµÈЧ¹¦ÄÜ
DBMS_ROWID »ñµÃROWID µÄÏêϸÐÅÏ¢
DBMS_RANDOM ÌṩËæ»úÉú³ÉÆ÷
DBMS_SQL ÔÊÐíÓû§Ê¹Óö¯Ì¬SQL,¹¹ÔìºÍÖ´ÐÐÈÎÒâDMLºÍDDLÓï¾ä
DBMS_JOB Ìá½»ºÍ¹ÜÀíÔÚÊý¾Ý¿âÖÐÖ´ÐеĶ¨Ê±ÈÎÎñ
DBMS_XMLDOM ÓÃDOMÄ£ÐͶÁдXMLÀàÐ͵ÄÊý¾Ý
DBMS_XMLPARSER XML½âÎö,´¦ÀíXMLÎĵµÄÚÈݺͽṹ
DBMS_XMLGEN ½«SQL ²éѯ½á¹ûת»»Îª¹æ·¶µÄXML¸ñʽ
DBMS_XMLQUERY Ìṩ½«Êý¾Ýת»»ÎªXMLÀàÐ͵ŦÄÜ DBMS_XSLPROCESSOR ÌṩXSLT¹¦ÄÜ. ת»»XMLÎĵµ
UTL_FILE ÓÃPL/SQL³ÌÐòÀ´¶Áд²Ù×÷ϵͳÎı¾Îļþ
DBMS_OUTPUTÖеÄһЩ¹ý³Ì
Enable
Disable
Put ½«×Ö·û·ÅÈ뻺³åÇø
Put_line ½«»º³åÇøÖÐÊý¾ÝÊä³ö²¢»»ÐÐ
New_line
Get_line
Get_lines
DBMS_LOB(Ö»ÄÜÓÉsysȨÏÞ²ÅÄܲÙ×÷)
append
compare
copy
erase
fileclose
fileexists
filegetname
getlength
/*´´½¨ÏÂÔØĿ¼±í£¬ÒԼǼÏÂÔصĸ÷ÖÖÎļþ*/
Create Table DownFileList
(
Id Varchar(20) Not Null Primary Key,
Name Varchar(40) Not Null,
FileLocation BFILE,/*Îļþ´æ·ÅλÖÃ*/
Description CLOB/*ÎļþÃèÊö*/
)
/*
´´½¨Ä¿Â¼
Create Or Replace Directory Ŀ¼Ãû AS '±¾µØ»òÍøÂç¹²Ïí·¾¶Ãû';
Create Or Replace Directory FILEDIR AS 'D:\down' »òÕß '\\SERVER\down' \\·þÎñÆ÷Ãû\¹²ÏíÃû
*/
Create Or Replace Directory FILEDIR AS 'D:\temp';--Ö¸¶¨FILEDIRΪ D:\temp Ŀ¼£¨¸ÃĿ¼±ØÐë´æÔÚ£©
insert into downfilelist values
('1001','oracle',BFILENAME(upper('filedir'),'oracle.txt'),'ÕâÊÇÒ»±¾oracleµÄ½Ì³Ì');

ÔÚselect * from downfilelist;ÃüÁîÊÇ£¬BFILE×Ö¶ÎÎÞ·¨ÏÔʾ£¬ÐèҪʹÓÃReadº¯Êý¶ÁÈ¡¡£
read
declare


Ïà¹ØÎĵµ£º

¹ØÓÚplsqlÖеÄdefine±äÁ¿ÒÔ¼°Oracle±äÁ¿·ÖÀàС½á

¹ØÓÚplsqlÖеÄdefine±äÁ¿ÒÔ¼°Oracle±äÁ¿·ÖÀàС½á
2009-07-29 15:18
ÏȼÇÔظÕÀ§ÈÅÎÒµÄÒ»¸öÎÊÌ⣬×î½üѧϰplsql£¬ÓÉÓÚËùÓÃѧϰÊé¼®ºóÃæÌṩÌâÄ¿³£Óõ½define±äÁ¿£¬µ«ÓÉÓÚÕâÒ»±äÁ¿µÄʹÓÃÌØÊâÐÔ£¬×Ô¼º±ãѰ˼ÕâÒ»±äÁ¿ËùÊéÀà±ð£¬OracleÌṩµÄ±äÁ¿·ÖÀ๲ÓÐËÄÀࣺ
1£©±êÁ¿£¨scalar£©ÀàÐÍ
2£©¸´ºÏ£¨composite£©ÀàÐÍ
3£©²ÎÕÕ£¨re ......

.NetÓëOracleµÄÊý¾Ý¿âÁ¬½Ó³Ø


ʱ¼ä: 2006-06-15  À´×Ô£ºCSDN
< type="text/javascript"><!--
google_ad_client = "pub-0103898066674568";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text";
google_ad_channel = "";
google_color_ ......

OracleÊý¾Ý¿âÉè¼Æ

Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔÇ°²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
 ¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......

֪ʶС½á(Oracle)

1)µ¼ÈëoracleÊý¾Ý¿âÎļþ.dmpʱ³öÏÖ´íÎó
imp PERSONNEL_MANAGE/MWQ@MIS file=C:\personnel_manage.dmp fromuser=PERSONNEL_MANAGE ignore=y commit=y grants=y;
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: invalid username/password; logon denied̞:
¿ÚÁî:
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: in ......

Oracle Listener ·þÎñ²»ÄÜÆô¶¯µÄÁíÒ»·¢ÏÖ

    ×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔÇ°·¢ÏÖ²»ÄÜÆô¶¯µÄÔ­ÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔÇ°µÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔÇ°µÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
    ×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ