SQL SERVER 语句
UPDATE StatusA SET status=2, @var = AIP
WHERE AIP = (SELECT MIN(AIP) FROM StatusA WHERE status = 1 )希望转为 ORA PL*SQL:
UPDATE StatusA SET status=2, ????
WHERE AIP = (SELECT MIN(AIP) FROM StatusA WHERE status = 1 )其中的变量赋值部分该如何写?
UPDATE StatusA SET status=2, @var = AIP
WHERE AIP = (SELECT MIN(AIP) FROM StatusA WHERE status = 1 )希望转为 ORA PL*SQL:
UPDATE StatusA SET status=2, ????
WHERE AIP = (SELECT MIN(AIP) FROM StatusA WHERE status = 1 )其中的变量赋值部分该如何写?
...
UPDATE StatusA SET status=2 WHERE AIP = (SELECT MIN(AIP) FROM StatusA WHERE status = 1 ) returning aip into v_aip;