#2
纳兰伽香2015-04-11 17:45
|
SELECT DISTINCT "GY_BQDM"."BQDM",
"GY_BQDM"."BQMC",
"GY_BQDM"."PXXH"
FROM "GY_BQDM",
"BY_FYKSDZ"
WHERE ( "GY_BQDM"."BQDM" = "BY_FYKSDZ"."BQDM" ) and
( "BY_FYKSDZ"."XTXH" = :p_xtxh ) AND
( "BY_FYKSDZ"."FYKS" = :p_ksdm ) AND
( "BY_FYKSDZ"."SYPB" = 1 ) AND
( NVL("GY_BQDM"."ZFPB",0)<>1)
ORDER BY "GY_BQDM"."BQMC" ASC
:p_xtxh = '36.00000000000000000'
:p_ksdm = '2010902'
这段代码有3个疑问:
1、"GY_BQDM"."BQMC"之类的为什么加引号?有作用?
2、:p_xtxh 和:p_ksdm 前面的冒号是什么意思,必须加么?
3、最后 '36.00000000000000000'为什么小数点后那么多位?谢谢。