Oracle èªå®ä¹TYPE çå ç§ç¨æ³
Oracleä¸çç±»åæå¾å¤ç§ï¼ä¸»è¦å¯ä»¥å为以ä¸å ç±»ï¼
1ãå符串类åãå¦ï¼charãncharãvarchar2ãnvarchar2ã
2ãæ°å¼ç±»åãå¦ï¼intãnumber(p,s)ãintegerãsmallintã
3ãæ¥æç±»åãå¦ï¼dateãintervalãtimestampã
4ãPL/SQLç±»åãå¦ï¼pls_integerãbinary_integerãbinary_double(10g)ãbinary_float(10g)ãbooleanãplsqlç±»åæ¯ä¸è½å¨sqlç¯å¢ä¸ä½¿ç¨çï¼æ¯å¦å»ºè¡¨æ¶ã
5ãèªå®ä¹ç±»åã
ä¸é¢ç®åçæ举ä¸å¸¸ç¨çå ç§èªå®ä¹ç±»åã
1ãåç±»åã
è¿ç§ç±»åæç®åï¼ç±»ä¼¼ç±»åçä¸ä¸ªå«åï¼ä¸»è¦æ¯ä¸ºäºå¯¹å¸¸ç¨çä¸äºç±»åç®ååï¼å®åºäºåå§çæ个类åãå¦ï¼
æäºåºç¨ä¼ç»å¸¸ç¨å°ä¸äºè´§å¸ç±»åï¼number(16,2)ãå¦æå¨å
¨å±èå´åèªå®ä¹è¿ç§ç±»åï¼ä¸æ¦éè¦ä¿®æ¹è¯¥ç±»åç精度ï¼åéè¦ä¸ä¸ªä¸ªå°ä¿®æ¹ã
é£å¦ä½å®ç°å®ä¹çå
¨å±åå¢ï¼äºæ¯å°±å¼åºäºåç±»åï¼
subtype cc_num is number(16,2);
è¿æ ·å°±å¾æ¹ä¾¿å°è§£å³äºä¸è¿°ç麻ç¦ã
2ãæ®éç±»å
å¦ï¼
create or replace type typ_calendar as object(
å¹´ varchar2(8),
æ varchar2(8),
æææ¥ varchar2(8),
ææä¸ varchar2(8),
ææäº varchar2(8),
ææä¸ varchar2(8),
ææå varchar2(8),
ææäº varchar2(8),
ææå
varchar2(8),
æ¬ææåä¸æ¥ varchar2(2)
);
è¿ç§ç±»åå¯ä»¥å¨è¡¨ç»æå®ä¹çæ¶å使ç¨ï¼
create table tcalendar of typ_calendar;
æå
¥æ°æ®æµè¯ï¼
SQL> insert into tcalendar
2 select typ_calendar('2010','05','1','2','3','4','5','6','7','31') from dual
3 /
注æï¼æå
¥çæ°æ®éè¦ç¨typ_calendarè¿è¡è½¬æ¢ã
1 row inserted
--æ¥çç»æ
SQL> select * from tcalendar;
温馨提示:答案为网友推荐,仅供参考