|
#175. The STUDENT table contains these columns: STU_ID NUMBER(9) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_NAME VARCHAR2(25) NOT NULL
DOB DATE
STU_TYPE_ID VARCHAR2(1) NOT NULL
ENROLL_DATE DATE You create another table, named PT_STUDENT, with an identical structure. You want to insert all part-time students, who have a STU_TYPE_ID value of "P", into the new table. You execute this INSERT statement: INSERT INTO pt_student (SELECT stu_id, last_name, first_name, dob, SYSDATE FROM student WHERE UPPER(stu_type_id) = 'P');
What is the result of executing this INSERT statement?
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.046
Forum
Master braindump