oracle Function
5.µ÷Óú¯ÊýFN_ADDONE
--------------------
SQL> SET SERVEROUTPUT ON
SQL> DECLARE CNUM NUMBER;
2 BEGIN
3 CNUM := USER1_ADB.FN_ADDONE(3);
4 DBMS_OUTPUT.PUT_LINE('CNUM = ' || CNUM);
5 END;
6 /
CNUM = 4
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
6.ɾ³ýº¯ÊýFN_ADDONE
--------------------
SQL> DROP FUNCTION USER1_ADB.FN_ADDONE;
Ïà¹ØÎĵµ£º
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle×Ô´øÎĵµÐ´µÄ±È½ÏÇå³þ
24
DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides suppo ......
1. ×¼±¸¹¤×÷
°Ñ¾ÉµÄORACLEËùÓÐÎļþ¶¼COPY±¸·ÝÏÂÀ´,ɾ³ý¾ÉĿ¼,ÔÙÖØÐ°²×°ORACLE,Ŀ¼ºÍ¾ÉĿ¼һÑù(Èç¹û²»Ò»Ñù,ÒªÐ޸ĵĵط½±È½Ï¶à).Ö»°²×°ORACLE,²»´´½¨Êý¾Ý¿â¡£Òª»Ö¸´µÄʵÀýΪORCL ¡£
2.ÓÃÃüÁʽ£¬Í¨¹ýÒª¾ÉµÄORAÎļþ´´½¨ÐµÄʵÀýORCL
a) oradim -new -sid ORCL£¨´´½¨ÊµÀý£ ......
1¡¢OracleÀïÃæÓû§µÄÃÜÂëÊǽøÐмÓÃܱ£´æµÄ,ËùÒÔÖ»ÄÜÖØÐÂÐÞ¸ÄÉú³ÉеÄÃÜÂë.
ÀûÓÃϵͳ¹ÜÀíÔ±(sys)µÇ¼,½«scottÓû§µÄÃÜÂëÐ޸ļ´¿É
SQL>conn / as sysdba ;
ÒÑÁ¬½Ó¡£
SQL>alter user scott identified by tiger
;
Óû§ÒѸü¸Ä¡£
µ±È»Ò²¿ÉÒÔµ½WEB¶Ë½øÐÐÐ޸ĵØÖ·È ......
--oracle jobsÅú´¦ÀíÃüÁî²Î¿¼
qlplus /nolog
connect sys/lee as sysdba
--ÒÔÏÂÁ½¾äÔÚsys(¼´¾ßÓÐdbaȨÏÞµÄÓû§)Óû§ÏÂÖ´ÐÐ
show parameter job_queue_processes;
alter system set job_queue_processes=10;
exit
sqlplus /nolog
connect jcy/jcy
ALTER TABLE T_OA_AFFICHE MODIFY (INPUT_TIME DATE);
ALTER TABLE ......