ORACLE 变量赋值问题？

[szctrl]

查询出来的值怎么赋值不了给变量pmd呢？
我是在存储过程里写的

pmd char
pmd:=select max(salesdate) from lsdp

DELETE FROM LFDP where salesdate=pmd

[秋雨飘落]

select max(salesdate) into pmd from lsdp;

不明白看我空间加qq

[tangren]

先找本书看看吧：《精通oracle 10g pl/sql编程》
或者找个视频看看：韩顺平《玩转ORACLE》

[fendou1314]

兄弟，你的写法是有问题的。应该使用select into 语法

pmd char;

select max(salesdate)into pmd from lsdp;

接着你可以使用dbms_put函数来查看pmd变量。

[huangdh12]

pmd:=select max(salesdate) from lsdp
没有这样写法的。

[304的的哥]

delete from lsbp a
where salesdate=(
select max(salesdate) from lsdp b
where a.id=b.id);

[kyousuke]

[Quote=引用 1 楼 zftang 的回复:]
select max(salesdate) into pmd from lsdp;

不明白看我空间加qq
[/Quote]
+1

[mingchaoyan]

select。。 into。。

[redlotus_lyn]

pmd number;
select max(salesdate) into pmd from lsdp;

[sych888]

select max(salesdate) into 变量 from lsdp