Команды SQL:CREATE TYPE relative_type AS OBJECT (first_name VARCHAR2(30),last_name VARCHAR2(30),birth_date DATE,MEMBER FUNCTION age RETURN NUMBER);
CREATE TABLE relatives (relation relative_type,description VARCHAR2(100));
Вставку строки в таблицу RELATIVES возможно выполнить при помощи команды:
(Отметьте один правильный вариант ответа.)
Варианты ответа
INSERT INTO relative_type (relation, description)VALUES ('Ekaterina', 'Ivanova', TO_DATE('10-12-1920','DD-MM-YYYY'), 90, 'My grandmother');
INSERT INTO relatives (relation, description)VALUES ('Ekaterina', 'Ivanova', TO_DATE('10-12-1920','DD-MM-YYYY'), 90, 'My grandmother');
INSERT INTO relatives (relation, description)VALUES (relative_type ('Ekaterina', 'Ivanova', TO_DATE('10-12-1920','DD-MM-YYYY')), 'My grandmother');(Верный ответ)
INSERT INTO relation (description, relation)VALUES ('My grandmother', relative_type ('Ekaterina', 'Ivanova', TO_DATE('10-12-1920','DD-MM-YYYY'), 90));