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

oracleÖÐtypeµÄʹÓÃ

create or replace type mytype IS TABLE OF varchar2(20);
declare type1 mytype :=mytype('1','2','3','4');
i number:=1;
var_str varchar(20):='liaomin';
begin
type1.EXTEND;
type1(type1.COUNT):=var_str;
loop
  dbms_output.put_line(type1(i));
  i:=i+1;
  exit when i=type1.count+1;
 end loop;
end;
×¢ÒâµØ·½  IS TABLE OF varchar2(20); ±íʾ±í¸ñÖеÄvarchar2(20) Ï൱ÓÚÒ»ÁÐÊý¾Ý ÕâÀï¾Í±íʾÊý×é
type1ÐèÒªÌí¼ÓÊý¾Ý ±ØÐëµ÷Óà EXTENDÌí¼ÓÒ»·ÝµØÖ·  Æäʵ×îºóÒ»¸öλÖà Ҳ¾ÍÊǸÃÌí¼ÓÖµµÄµØ·½
×¢Òâ ¸ÃÊý×éµÄϱêÊÇ´Ó 1¿ªÊ¼µÄ


Ïà¹ØÎĵµ£º

³éÏóÊý¾ÝÀàÐÍ£¬ÈÃOracleÊý¾Ý¿âÊý¾Ý¹ÜÀí¸ü¼ÓÈÝÒ×

2¡¢ ³éÏóÊý¾ÝµÄÒýÓá£
¡¡¡¡µ±½¨Á¢ºÃ³éÏóÊý¾ÝÀàÐ͵Äʱºò£¬Êý¾Ý¿â¹ÜÀíÔ±¾Í¿ÉÒÔÏò»ù±¾Êý¾ÝÀàÐÍÄÇÑù£¬ÒýÓóéÏóÊý¾ÝÀàÐÍ£¬°üÀ¨ÔÚ½¨Á¢±í»òÕß¶ÔÏà¹Ø×ֶνøÐи³ÖµµÄʱºò£¬¶¼Õâô·½±ã¡£
¡¡¡¡ÈçÔÚ½¨Á¢±íµÄʱºò£¬¿ÉÒÔ°ÑÕâ¸ö³éÏóÊý¾ÝÀàÐÍÖ±½Ó¸úij¸ö×ֶιØÁªÆðÀ´¡£Èç
¡¡¡¡Create Table USERS
¡¡¡¡(F­­_Adress Adress );
¡¡¡ ......

OracleµÄÓû§¹ÜÀí ORA

ÅäÖÃÉí·ÝÑéÖ¤
OracleΪÓû§ÕË»§ÌṩÈýÖÖÉí·ÝÑéÖ¤·½·¨£º
(1)ÃÜÂëÑéÖ¤
µ±Ò»¸öʹÓÃÃÜÂëÑéÖ¤»úÖÆµÄÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµØÊý¾Ý¿âÓû§£¬²¢ÇÒÌṩÓë¸ÃÓû§ÔÚÊý¾Ý¿âÖд洢µÄÃÜÂëÏàÆ¥ÅäµÄÃÜÂë¡£
(2)ÍⲿÑéÖ¤
µ±Ò»¸öÍⲿÑé֤ʽÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµÄ ......

¹ØÓÚOracleÖÐtnsnames.oraµÄÅäÖÃ


ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
  (DESCRIPTION =
    (ADDRESS_LIST =
      ......

oracleÈÕÆÚº¯Êý¼¯½õ

Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from ......

oracleÈÕÆÚʱ¼äº¯Êý´óÈ«

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê               ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ