[seasar-dotnet:1605] Re: 外だしＳＱＬについて

[Hiroaki Fujii]

$BF#0f$G$9!#(B

$B40A4$K0l=o$G$O$J$$$N$G$9$,!"(BOracle10gXE$B!"(BODP$B!"(BQuill$B$,(B1.3.17$B$N(B
$B4D6-$G<B9T$7$^$7$?$,!":F8=$7$^$;$s$G$7$?!#(B

$B$b$&>/$7D4$Y$kA0$K!"$*4j$$$J$N$G$9$,!"(BS2Dao.NET$BMQ$N%$%s%?!<%U%'%$%9$N(B
$B=q$-J}$O4V0c$($F$$$k$3$H$O$J$$$G$7$g$&$+!)(B
$B0z?t$d(B2$B%P%$%HJ8;z$N4A;z$d(B1$B%P%$%HJ8;z$r%W%m%Q%F%#$J$I$G:.:_$7$F(B
$B;H$o$l$F$$$k$h$&$G$9$,!"$3$l$i$r4V0c$($F;H$C$F$$$k$3$H$O$J$$(B
$B$G$7$g$&$+!)(B

$B$=$l$H!"(BSQL$BJ8$b$3$l$GK\Ev$KDL$k$+3NG'$r$*4j$$$7$^$9!#(B
WHERE$B6g$NCf$N(BAND$B$r(BOR$B$KJQ$($?$i(Bsqlplus$B$G(B2$B7o5"$C$F$-$^$7$?!#(B

$B3NG'$r$*4j$$$$$?$7$^$9!#(B


$B-j%M%9%F%#!!:{LZ!!M*0m(B $B$5$s$O=q$-$^$7$?(B:
> $B$O$8$a$^$7$F!#(B
> $B:{LZ$H?=$7$^$9!#(B
>  
> $B30$@$7#S#Q#L$K$D$$$F<ALd$5$;$F2<$5$$!#(B
> $B%Q%i%a!<%?%3%a%s%H$KA43QJ8;z$r;XDj$9$k$H!"(B
> $BA[Dj$5$l$k7k2L$r<hF@$G$-$J$$$3$H$,$"$j$^$9!#(B
>  
> $B%Q%i%a!<%?%3%a%s%H$r;HMQ$;$:$K!"D>@\=q$-9~$s$G(B
> $B<B9T$7$?>l9g$O!";W$C$?$H$*$j$N7k2L$r<hF@$G$-$^$9!#(B
>  
> $B2?$[E-MAIL ADDRESS DELETED]$,I,MW$J$N$G$7$g$&$+!)(B
> $B0J2<!"<B9TFbMF$G$9!#(B
>  
> $B"#3+H/4D6-(B
> $B!!(BOS:WindowsXP
> $B!!(BVisualStudio2008
> $B!!(B.NetFrameWork3.5
> $B!!(BOracle11g(OS:Windos2008)
> $B!!(BS2Container.NET 1.3.17.0
> $B!!(BS2Dao.NET 1.3.17.0
>  
> $B"#%F!<%V%k(B
> $B!&%F!<%V%kL>(B
> $B!!!!(BM_$B%l%C%9%s(B
> $B!&%U%#!<%k%I(B
> $B!!!!E9J^!!!!!!(BNUMBER(3,0)$B!!!J(BPK$B!K(B
> $B!!!!F|IU!!!!!!(BVARCHAR2(8)$B!!!J(BPK$B!K(B
> $B!!!!3+;O;~9o!!(BVARCHAR2(4)$B!!!J(BPK$B!K(B
> $B!!!!=*N;;~9o!!(BVARCHAR2(4)
> $B!!!!%3!<%9!!!!(BVARCHAR2(6)
>  
> $B"#>e5-%F!<%V%kFb$N%l%3!<%I(B
> $B!!(B1,"20100301","1000","1100","T$B=i5i(B"
> $B!!(B1,"20100301","1100","1200","T$BCf5i(B"
> $B!!(B1,"20100301","1200","1300","T$B>e5i(B"
>  
> $B"#<B9T-!!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ!K(B
>  
> SELECT *
>   FROM M_$B%l%C%9%s(B
>  WHERE $B%3!<%9(B >= /*pmb.$B%3!<%9(BFROM*/
>    AND $B%3!<%9(B <= /*pmb.$B%3!<%9(BTO*/
>  
> $B%Q%i%a!<%?CM(B
> $B!!(Bpmb.$B%3!<%9(BFROM$B"*(B'T$B=i5i(B'
> $B!!(Bpmb.$B%3!<%9(BTO$B"*(B'T$B>e5i(B'
>  
> $B"M8!:w7k2L$O!"%l%3!<%I$J$7$H$J$j$^$9!#(B
>  
> $B!J#S#Q#L%m%0!K(B
> Seasar.Extension.ADO.Impl.BasicSelectHandler: 2010-03-17 12:01:30,400 
> [1] DEBUG Seasar.Framework.Log.Logger Debug - SELECT *
>   FROM M_$B%l%C%9%s(B
>  WHERE $B%3!<%9(B >= 'T$B=i5i(B'
>    AND $B%3!<%9(B <= 'T$B>e5i(B'
>  
> $B"#<B9T-"!J30$@$7#S#Q#L$G%Q%i%a!<%?%3%a%s%H$r;HMQ$r$7$J$$!K(B
>  
> SELECT *
>   FROM M_$B%l%C%9%s(B
>  WHERE $B%3!<%9(B >= 'T$B=i5i(B'
>    AND $B%3!<%9(B <= 'T$B>e5i(B'
>  
> $B"M8!:w7k2L$O!"%l%3!<%I#27o$H$J$j$^$9!#(B
> $B!!(B1,"20100301","1000","1100","T$B=i5i(B"
> $B!!(B1,"20100301","1200","1300","T$B>e5i(B"
>  
> $B#S#Q#L%D!<%k$G<B9T$7$?>l9g$O!"7k2L-"$HF1$8$G$9!#(B
> $B<B9T-!$G!"<B9T-"$HF1$87k2L$r<hF@$9$k$?$a$K$O(B
> $B$I$&$$$C$?@_Dj$,I,MW$J$N$G$7$g$&$+!)(B
>  
> $B0J>e!"59$7$/$*4j$$?=$7>e$2$^$9!#(B
>  
> $B:{LZ(B
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> seasar-dotnet mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-dotnet