i need a spool file from the instructions
copy/paste the text please
- I Need A Spool File From The Instructions Copy Paste The Text Please 1 (52.9 KiB) Viewed 11 times
SQL> CREATE TABLE Students( z_no NUMBER, name VARCHAR2 (50), age NUMBER, PRIMARY KEY (z_no)); Add an attribute (column) SQL > ALTER TABLE Students ADD gpa real; Insert a student: SQL > INSERT INTO Students (z_no, name, age, gpa) VALUES (1122334, 'Tom Jones', 24, 4.0); Insert a student: SQL> INSERT INTO Students (z_no, name, age, gpa) VALUES (1122335, 'Smith', 21, 3.6); Insert a student: --(will not allow to insert 2 with the identical Primary Key) SQL > INSERT INTO Students (z_no, name, age, gpa) VALUES (1122335, 'Gordon', 38, 2.5); Find all the students: SQL> SELECT * FROM Students; Remove a student: SQL>DELETE FROM Students WHERE z_no = 1122335; Remove all students: SQL>DELETE FROM students; Insert a student: SQL > INSERT INTO Students (z_no, name, age, gpa) VALUES (1122334, 'Tom Jones', 24, 4.0);
Insert a student: SQL> INSERT INTO Students (z_no, name, age, gpa) VALUES (1122335, 'Smith', 21, 3.6); Insert a student: SQL > INSERT INTO Students (z_no, name, age, gpa) VALUES (1122336, 'Gordon', 38, 2.5); Update: SQL> UPDATE Students SET gpa gpa + .5 WHERE z_no=1122336; Update: SQL> UPDATE Students SET name WHERE z_no = 1122336; Print the entire student table: SQL> SELECT * FROM students; 'Popcorn', age 85