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

PL/SQLѧϰ±Ê¼Ç¶þ


1.³£Á¿
¶¨ÒåÓï·¨¸ñʽ£º
³£Á¿Ãû constant ÀàÐͱêʶ·û [not null]:=Öµ;
È磺PI constant number(9):=3.1415;
2.»ù±¾Êý¾ÝÀàÐͱäÁ¿
»ù±¾Êý¾ÝÀàÐÍ
number  Êý×ÖÐÍ
int ÕûÊýÐÍ
pls_integer ÕûÊýÐÍ£¬²úÉúÒç³öʱ³öÏÖ´íÎó
binary_integer ÕûÊýÐÍ£¬±íʾ´ø·ûºÅµÄÕûÊý
char ¶¨³¤×Ö·ûÐÍ£¬×î´ó255¸ö×Ö·û
varchar2 ±ä³¤×Ö·ûÐÍ£¬×î´ó2000¸ö×Ö·û
long ±ä³¤×Ö·ûÐÍ£¬×î´ó2GB
date ÈÕÆÚÐÍ
boolean ²¼¶ûÐÍ£¨true,false,nullÈýÕßÖ®Ò»£©
»ù±¾Êý¾ÝÀàÐͱäÁ¿µÄ¶¨ÒåÓï·¨¸ñʽ
±äÁ¿Ãû ÀàÐͱêʶ·û [not null]:=Öµ;
È磺myvar varchar2(10):='right';
3.¸´ºÏÊý¾ÝÀàÐͱäÁ¿
3.1 ±í×Ö¶ÎÀàÐͱäÁ¿(ʹÓÃ%type¶¨Òå)
±äÁ¿µÄÀàÐÍÓëÊý¾Ý±íÖеÄ×ֶεÄÊý¾ÝÀàÐÍÒ»Ö¡£µ±Êý¾Ý¿â±íµÄ×Ö¶ÎÀàÐÍÐ޸ĺó£¬ÏàÓ¦µÄ±äÁ¿µÄÀàÐÍÒ²×Ô¶¯Ð޸ġ£
¶¨ÒåÓï·¨¸ñʽ£º±äÁ¿Ãû ±í×Ö¶ÎÃû%type;
È磺mydate tempuser.testtable.currentdate%type ¶¨ÒåÁËÃûΪmydateµÄ±äÁ¿£¬ÆäÀàÐÍÓëtempuser.testtable±íÖеÄcurrentdate×Ö¶ÎÀàÐÍÒ»Ö¡£
3.2 ¼Ç¼ÀàÐͱäÁ¿
¼Ç¼ÀàÐͶ¨ÒåÓï·¨¸ñʽ£º
type Êý¾ÝÀàÐÍÃû is record(
     ×Ö¶Î1 ÀàÐͱêʶ·û1£¬
     ×Ö¶Î2 ÀàÐͱêʶ·û2£¬
     ...
);
¼Ç¼ÀàÐͱäÁ¿¶¨Ò壺
±äÁ¿Ãû Êý¾ÝÀàÐÍÃû;
È綨Òå¼Ç¼ÀàÐÍ£º
type myrecord is record(myrecordnumber int, mycurrentdate date);
¶¨ÒåmyrecordÀàÐͱäÁ¿srecord£º
srecord myrecord;
·ÃÎÊmyrecordnumber×Ö¶ÎÖµ£º
srecord.myrecordnumber
×¢Ò⣺×Ö¶Î1£¬×Ö¶Î2µÈÒ²¿ÉÒÔÊǸ´ºÏÊý¾ÝÀàÐÍ¡£
3.3 ±í¼Ç¼ÐͱäÁ¿£¨Ê¹ÓÃ%rowtype¶¨Ò壩
¶¨ÒåÓï·¨¸ñʽ£º±äÁ¿Ãû ±íÃû%rowtype
±äÁ¿¿ÉÒÔ»ñµÃÕû¸ö±í¼Ç¼µÄÊý¾ÝÀàÐÍ£¬Ï൱ÓÚÏȶ¨ÒåÁËÒ»¸ö¼Ç¼ÀàÐÍ£¬Æä¸÷×Ö¶ÎÀàÐÍ·Ö±ð¶ÔÓ¦±íµÄ¸÷×Ö¶ÎÀàÐÍ£»È»ºóÔÙ¶¨ÒåÕâÖּǼÀàÐ͵ıäÁ¿
3.4 һά±íÀàÐͱäÁ¿
¶¨ÒåÓï·¨¸ñʽ£º
type ±íÀàÐÍ is table of ÀàÐÍ index by binary_integer;
±íÀàÐͱäÁ¿Ãû ±íÀàÐÍ;
Ï൱¶¨ÒåһάÊý×飬ÕâÀïµÄÀàÐÍ¿ÉÒÔÊÇÇ°ÃæµÄÀàÐͶ¨Ò壬index by binary_integer×Ó¾ä´ú±íÒÔ·ûºÅÕûÊýΪË÷Òý£¬ÕâÑù·ÃÎʱíÀàÐͱäÁ¿ÖеÄÊý¾Ý·½·¨¾ÍÊÇ“±í±äÁ¿Ãû(Ë÷Òý·ûºÅÕûÊý)“¡£
ʾÀý£º
declare 
  type tabletype1 is table of varchar2(4) index by binary_integer; --¶¨Òåһά±íÀàÐÍtabletype1
  type tabletype2 is table of tempuser.testtable."recordnumber"%type index by binary_integer; --


Ïà¹ØÎĵµ£º

²¹³ä£ºv$sql,v$sqlarea,v$sqltextÓÐÊ²Ã´Çø±ð

http://inthirties.com:90/thread-1202-1-1.html
Ç°ÃæÎÄÕ ”v$sql,v$sqlarea,v$sqltextÓÐÊ²Ã´Çø±ð“ ¼û http://blog.csdn.net/inthirties/archive/2010/03/10/5364777.aspx
ÕâÀï²¹³äÒ»ÏÂ
²¹³ä£º
1¡¢²éÒ»ÏÂÕâЩÊÓͼµÄ¶¨ÒåÄã¾ÍÄÜÀí½â£¬ËüÃǵÄÔ´¶¼ÊÇÒ»¸ö¡£
SELECT view_definition from v$fixed_view_definiti ......

SQL Server±¨´íChinese_PRC_90_CI_AS

SQL Server 2005±¨ÁËÕâô¸ö´í£ºCannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_PRC_90_CI_AS" in the like operation.
ºó²éÖ¤£¬ÕâÊÇÓÉÓÚÁ½¸ö×ö±È½ÏµÄÁеÄÅÅÐò·½Ê½²»Í¬£¬ÖÐÎÄÓкܶàÖÖÅÅÐò·½Ê½£¬¶ÔÓ¦ÈçÏ£º
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐÐÕþÇø£©
Chinese_Hong_Kong_Stroke_90_CI_AS
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐ ......

SQLÓï¾ä²éѯÊÇ·ñΪ¿Õ =null¼°null

  a                  b                             c&nb ......

.net³ÌÐòÔ±ËùÐèÕÆÎÕµÄsql£¬»ù±¾¼¼ÇÉ(2)

1. ¼òÊö private¡¢ protected¡¢ public¡¢ internal ÐÞÊηûµÄ·ÃÎÊȨÏÞ¡£
´ð . private :  ˽ÓгÉÔ±, ÔÚÀàµÄÄÚ²¿²Å¿ÉÒÔ·ÃÎÊ¡£
    protected : ±£»¤³ÉÔ±£¬¸ÃÀàÄÚ²¿ºÍ¼Ì³ÐÀàÖпÉÒÔ·ÃÎÊ¡£
    public :    ¹«¹²³ÉÔ±£¬ÍêÈ«¹«¿ª£¬Ã»ÓзÃÎÊÏÞÖÆ¡£
    internal:  ÔÚÍ¬Ò ......

sql server·ÃÎÊÔ¶³ÌÊý¾Ý¿â

--´´½¨Á´½Ó·þÎñÆ÷
exec sp_addlinkedserver   'ITSV ', ' ', 'SQLOLEDB ', 'Ô¶³Ì·þÎñÆ÷Ãû»òipµØÖ· '
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, 'Óû§Ãû ', 'ÃÜÂë '
--²éѯʾÀý
select * from ITSV.Êý¾Ý¿âÃû.dbo.±íÃû
--µ¼ÈëʾÀý
select * into ±í from ITSV.Êý¾Ý¿âÃû.dbo.±íÃû
--ÒÔºó²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ