Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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; --


Ïà¹ØÎĵµ£º

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

1¡¢SessionÓÐʲôÖØ´óBUG£¬Î¢ÈíÌá³öÁËʲô·½·¨¼ÓÒÔ½â¾ö£¿
  ´ð£ºÊÇiisÖÐÓÉÓÚÓнø³Ì»ØÊÕ»úÖÆ£¬ÏµÍ³·±Ã¦µÄ»°Session»á¶ªÊ§£¬¿ÉÒÔÓÃSate server»òSQL ServerÊý¾Ý
¿âµÄ·½Ê½´æ´¢Session²»¹ýÕâÖÖ·½Ê½±È½ÏÂý£¬¶øÇÒÎÞ·¨²¶»ñSessionµÄENDʼþ¡£
2.²úÉúÒ»¸öintÊý×飬³¤¶ÈΪ100£¬²¢ÏòÆäÖÐËæ»ú²åÈë1-100£¬²¢ÇÒ²»ÄÜÖظ´¡£
C# ......

C#ÖвÙ×÷OracleʱµÄSQLÓï¾ä²ÎÊýµÄÓ÷¨

C#ÖвÙ×÷OracleʱµÄSQLÓï¾ä²ÎÊýµÄÓ÷¨
OracleTransaction myTrans ;
            conn.Open();
            myTrans =conn.BeginTransaction(IsolationLevel.ReadCommitted) ......

linq to sql ÖдÓdbmlÎļþÖд´½¨Êý¾Ý¿â

        ½ñÌìºÜÓôÃÆ,ʵÑéÊҵķþÎñÆ÷¶«Î÷¶¼Ã»ÓÐÁË,¶øÎÒµÄÊý¾Ý¿âÓÖÔÚÄÄÀï,ÎÒÓÖûÓб¸·Ý,°ÑÎÒÒÖÓôµÄÒªÃü,ÐÒ¿÷ÎÒÓõÄlinq to sql.×ÐϸÏëÏë,ËûµÄdbmlÎļþ»ù±¾°üº¬ÁËÊý¾Ý¿âµÄËùÓÐÄÚÈÝ,ËùÒÔ,Ò»¶¨Óа취´ÓdbmlÎļþÖд´½¨Êý¾Ý¿â!
        Ñо¿ÁËÒ»¶ÎÊ ......

Sql Server²é¿´ËùÓÐÊý¾Ý¿âÃû,±íÃû,×Ö¶ÎÃûSQL

1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ±í;
3.»ñÈ¡ËùÓÐ×Ö¶ÎÃû:
SELECT Name from SysColumns WHERE id=Object_Id('TableNam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ