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

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

³ÉÔ±º¯ÊýºÍ¹ý³Ì
¹¹Ô캯Êý·½·¨
-oracleµÄÿ¸ö¶ÔÏó¾ùÓÐÒ»¸öÄÚÖõĹ¹Ô캯Êý·½·¨
-ÓÃÓÚ´´½¨¶ÔÏóµÄÒ»¸öʵÀý
-ÎÞÐèÏÔʽµØ¶¨Òå
-Óë¶ÔÏóÀàÐÍͬÃû
¶¨Òå¶ÔÏóÀàÐÍ
create or replace
type persontype as object
(
  id int,
  name varchar(20),
  member function getId return int,
  member procedure setId(pid int),
  member function getName return varchar,
  member procedure setName(pname varchar)
)not final

ʵÏÖ¶ÔÏó³ÉÔ±·½·¨
create or replace type body persontype as
  function getId return int as
  begin
    return id;
  end getId;
 
  procedure setId(pid int) as
  begin
    id := pid;
  end setId;
 
  function getName return varchar as
  begin
    return name;
  end getName;
 
  procedure setName(pname varchar) as
  begin
    name := pname;
  end setName
²âÊÔ¶ÔÏó
declare
  p personType;
begin
  p:=personType(1,'pf');
  --Ö±½Ó·ÃÎʶÔÏó³ÉÔ±±äÁ¿
  dbms_output.put_line(p.id||'|'||p.name);
  --ʹÓ÷½·¨·ÃÎʳÉÔ±±äÁ¿ ÍƼö
  dbms_output.put_line(p.getId()||'|'||p.getName());
  --ʹÓÃset·½·¨¸ü¸Ä¶ÔÏó³ÉÔ±±äÁ¿Öµ
  p.setId(2);
  p.setName('lmj');
  dbms_output.put_line(p.getId()||'|'||p.getName());
end;
Êä³ö£º
1|pf
1|pf
2|lmj
ºÜÞÏÞεķ¢ÏÖ×îºóÒ»²¿ÊÓƵµÄºó°ë²¿·ÖºÍÇ°°ë²¿·ÖÊÇÒ»ÑùµÄ¡£¡£¡£囧¡£¡£¡£Ç¶Ì×±íûÓн²¡£¡£¡£
ÍøÉÏËÑÁËÒ»ÏÂǶÌ×±íµÄ×ÊÁÏ£¬ÈçÏ£º
Ò»¡¢Ç¶Ì×±íµÄ¶¨Ò壺
ǶÌ×±íÊDZíÖÐÖ®±í¡£Ò»¸öǶÌ×±íÊÇijЩÐеļ¯ºÏ£¬ËüÔÚÖ÷±íÖбíʾΪÆäÖеÄÒ»ÁС£¶ÔÖ÷±íÖеÄÿһÌõ¼Ç¼£¬Ç¶Ì×±í¿ÉÒÔ°üº¬¶à¸öÐС£ÔÚijÖÖÒâÒåÉÏ£¬ËüÊÇÔÚÒ»¸ö±íÖд洢һ¶Ô¶à¹ØϵµÄÒ»ÖÖ·½·¨¡£¿¼²éÒ»¸ö°üº¬²¿ÃÅÐÅÏ¢µÄ±í£¬ÔÚÈκÎʱ¼äÄÚÿ¸ö²¿ÃÅ»áÓкܶàÏîÄ¿ÕýÔÚʵʩ¡£ÔÚÒ»¸öÑϸñµÄ¹ØϵģÐÍÖУ¬½«ÐèÒª½¨Á¢Á½¸ö¶ÀÁ¢µÄ±ídepa


Ïà¹ØÎĵµ£º

´«ÖDz¥¿Í——Êý¾Ý¿âÖ®ORACLE£¨Èý£©


Ò» Êý¾Ý¿âµÄÊÂÎñ´¦Àí
¶¨Ò壺ÊÂÎñÊÇÒ»×éÏà¹ØµÄÊý¾Ý¸Ä±äµÄÂß¼­¼¯ºÏ¡£ÔÚÒ»¸öÊÂÎñÖеÄÊý¾Ý¸Ä±ä£¨DML£©±£³Ö×ÅÒ»ÖµÄ״̬£¬Êý¾ÝµÄ¸Ä±äͬʱ³É¹¦»òÕßͬʱʧ°Ü¡£
¶þ Êý¾Ý¿âµÄÊÂÎñÓÉÏÂÁÐÓï¾ä×é³É
Ò»×éDMLÓï¾ä£¬Ð޸ĵÄÊý¾ÝÔÚËûÃÇÖб£³ÖÒ»ÖÂ
Ò»¸ö DDL (Data Define Language) Óï¾ä
Ò»¸ö DCL (Data Control Language)Óï¾ä
1¡¢¿ª ......

ÈçºÎÔÚoracleÖе¼Èëµ¼³ödmpÊý¾Ý¿âÎļþ

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......

oracleÊý×Ö×Ö¶ÎÅжÏ

select nvl2(replace(translate('69584.00.00','.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber from dual;
select id,nvl2(replace(translate(id,'.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber
from tbl2 ......

oracleÖеĽÇÉ«


oracle
ÖеĽÇÉ«
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡ÎÒÔÚÇ°ÃæµÄƪ·ùÖÐ˵Ã÷ȨÏÞºÍÓû§¡£ÂýÂýµÄÔÚʹÓÃÖÐÄã»á·¢ÏÖÒ»¸öÎÊÌ⣺Èç¹ûÓÐÒ»×éÈË£¬
ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬µ±¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»áºÜ²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾Í
ÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ