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

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;


Ïà¹ØÎĵµ£º

Oracle±£Áô×Ö

²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
 OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬Èç ......

OracleÖеĴø²ÎÊýµÄÊÓͼ

OracleµÄÊÓͼ²»Ö§³Ö²ÎÊý
ÕâÀïÓÐÒ»¸öÁíÀàµÄ·½·¨£¬²»ÊǺܺ㬵«ÊÇ»¹ÊÇÒ»ÖÖ½â¾ö·½°¸
ͨ¹ýpackageʵÏÖ
create or replace package pkg_pv is
¡¡¡¡procedure set_pv(pv varchar2);
¡¡¡¡function get_pv return varchar2;
¡¡¡¡end;
¡¡¡¡create or replace package body pkg_pv is
¡¡¡¡v varchar2(20);
¡¡¡¡procedure set ......

oracleÊý¾ÝÎļþ»Ö¸´

1.    ×¼±¸¹¤×÷
°Ñ¾ÉµÄORACLEËùÓÐÎļþ¶¼COPY±¸·ÝÏÂÀ´,ɾ³ý¾ÉĿ¼,ÔÙÖØÐ°²×°ORACLE,Ŀ¼ºÍ¾ÉĿ¼һÑù(Èç¹û²»Ò»Ñù,ÒªÐ޸ĵĵط½±È½Ï¶à).Ö»°²×°ORACLE,²»´´½¨Êý¾Ý¿â¡£Òª»Ö¸´µÄʵÀýΪORCL ¡£
2.ÓÃÃüÁʽ£¬Í¨¹ýÒª¾ÉµÄORAÎļþ´´½¨ÐµÄʵÀýORCL
a)     oradim -new -sid ORCL£¨´´½¨ÊµÀý£ ......

oracle ¶ªÊ§ÃÜÂë

1¡¢OracleÀïÃæÓû§µÄÃÜÂëÊǽøÐмÓÃܱ£´æµÄ,ËùÒÔÖ»ÄÜÖØÐÂÐÞ¸ÄÉú³ÉеÄÃÜÂë.
ÀûÓÃϵͳ¹ÜÀíÔ±(sys)µÇ¼,½«scottÓû§µÄÃÜÂëÐ޸ļ´¿É
SQL>conn / as sysdba ;
ÒÑÁ¬½Ó¡£
SQL>alter user scott identified by tiger ;
Óû§ÒѸü¸Ä¡£
µ±È»Ò²¿ÉÒÔµ½WEB¶Ë½øÐÐÐ޸ĵØÖ·ÈçÏÂ:
http://localhsot:1158/em(ÏàÓ¦µÄ·þÎñ±Ø ......

Oracle±í¿Õ¼ä

Oracle´´½¨É¾³ýÓû§¡¢½ÇÉ«¡¢±í¿Õ¼ä¡¢µ¼Èëµ¼³ö¡¢...ÃüÁî×ܽá 
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace zfmi_temp
tempfile 'D:\oracle\oradata\zfmi\zfmi_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//tempfile²ÎÊý±ØÐëÓÐ
//´´½¨Êý¾Ý±í¿Õ¼ä
create table ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ