oracle sql 删除某表一条记录的问题？
要求用一条sql语句实现：
1.删除表A中员工id为1001的员工记录。
2.把1001的员工姓名取出来存入变量V_name中
请教各位大侠应该怎么实现？
[解决办法]
delete from 表 where id = 1001 return name into v_name
[解决办法]
delete from 表 where id = 1001 returning name into v_name
[解决办法]
delete from 表 where id = 1001 returning name into v_name
