oracle multiset distinct
DECLARE
TYPE limbs_t IS TABLE OF limb_ot;
l_limbs limbs_t;
BEGIN
SELECT limb_ot (l.nm, l.avg_len)
BULK COLLECT INTO l_limbs
FROM limbs l
ORDER BY l.nm;
l_limbs := l_limbs MULTISET EXCEPT l_limbs;
DBMS_OUTPUT.put_line ('Lots of limbs! ' || l_limbs.COUNT);
END;
/
PLS-00306: wrong number or types of arguments in call to 'MULTISET_EXCEPT_ALL"ORACLE multiset union distinct
DECLARE
TYPE limbs_t IS TABLE OF limbs%ROWTYPE;
l_limbs limbs_t;
BEGIN
SELECT l.nm, l.avg_len
BULK COLLECT INTO l_limbs
FROM limbs l
ORDER BY l.nm;
l_limbs := l_limbs MULTISET UNION l_limbs;
DBMS_OUTPUT.put_line ('Lots of limbs! ' || l_limbs.COUNT);
END;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
