SqlDeveloper Please help to correct insert statements below: INSERT INTO section

Question

SqlDeveloper

Please help to correct insert statements below:

INSERT INTO section
(section_id, course_no, section_no,
start_date_time,
location, instructor_id, capacity, created_by,
created_date, modified_by, modified_date)
VALUES
(500, 90, 1,
TO_DATE('03-APR-2008 15:00', 'DD-MON-YYYY HH24:MI'),
'L500', 103, 50, 'Your name here',
SYSDATE, 'Your name here', SYSDATE)

INSERT INTO instructor
(last_name, salutation, instructor_id,
created_by, created_date, modified_by, modified_date)
VALUES
('Spencer', 'Mister', 200,
'Your name', SYSDATE, 'Your name', SYSDATE)

Explanation / Answer

Above queries given are perfectly alright(Please check create table sysntax for mistakes)

INSERT INTO section
(section_id, course_no, section_no,
start_date_time,
location, instructor_id, capacity, created_by,
created_date, modified_by, modified_date)
VALUES
(500, 90, 1,
TO_DATE('03-APR-2008 15:00', 'DD-MON-YYYY HH24:MI'),
'L500', 103, 50, 'Your name here',
SYSDATE, 'Your name here', SYSDATE)

INSERT INTO instructor
(last_name, salutation, instructor_id,
created_by, created_date, modified_by, modified_date)
VALUES
('Spencer', 'Mister', 200,
'Your name', SYSDATE, 'Your name', SYSDATE)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.