ونستخدمها في جمله insert

SELECT ROWNUM N FROM dual
CONNECT BY LEVEL <= 20
هاي استخدمنها بس بطلع خطا بحكي
ORA-01427: single-row subquery returns more than one row

ORA-01427: single-row subquery returns more than one row

INSERT INTO fish_families
           (science_name, arabic_name,
            latin_name, is_family
           )
    VALUES ((SELECT DISTINCT family
                        FROM fish_species), (SELECT arabic_description
                                               FROM fish_species),
            (SELECT latin_description
               FROM fish_species), (SELECT DISTINCT is_family
                                               FROM fish_species)
           )

تم تعديل 13 مارس 201312 سنة بواسطة Ahmad.Hasan