Use the data from the class assignment, ALTER TABLE and add two more columns Phone and email. Describe the table (show its structure) and drop the country column, describe the table (show structure). Now, create a new table based on the existing table person with the help of a subquery (The new table will contain the data from “person” table) and name the table person_self. Show its output (table created and its structure). NOTE: Use the ALTER TABLE command with ADD clause Use the ALTER TABLE command with DROPCOLUMN clause Use the CREATE TABLE command with AS (SELECT SUBQUERY) clause

Use the data from the class assignment, ALTER TABLE and add two more columns Phone and email. Describe the table (show its structure) and drop the country column, describe the table (show structure). Now, create a new table based on the existing table person with the help of a subquery (The new table will contain the data from “person” table) and name the table person_self. Show its output (table created and its structure). NOTE: Use the ALTER TABLE command with ADD clause Use the ALTER TABLE command with DROPCOLUMN clause Use the CREATE TABLE command with AS (SELECT SUBQUERY) clause

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 3HOA: Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment...

See similar textbooks

Similar questions

Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees date of termination.
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5. All horses with breed Holsteiner or Paint. All horses born before March 13, 2013. NOTE: Starter code has been provided. Simply change the blanks ("_") to the appropriate entity/value.
WEEK 2 ASSIGNMENT Complete the following exercise: Using the student table you created in week one insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
Create a new table maned “Hiking” that includes TripID, NumPersons from Reservation table and Trip Type, Trip Name columns from Trip table where Trip type is “Hiking” .
WEEK 3 ASSIGNMENT Complete the following exercise: Using the student table you created in week two insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
Write ALTER TABLE statements for each table to create Primary Keys and Foreign Keys where applicable. (Preferable save to notepad) use exercise2: CREATE TABLE CUSTOMER ( CUS_CODE int, CUS_LNAME varchar(15), CUS_FNAME varchar(15), CUS_INITIAL varchar(1), CUS_AREACODE varchar(3), CUS_PHONE varchar(8), CUS_BALANCE float(8) ); INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','0'); INSERT INTO CUSTOMER VALUES('10011','Dunne','Leona','K','713','894-1238','0'); INSERT INTO CUSTOMER VALUES('10012','Smith','Kathy','W','615','894-2285','345.86'); INSERT INTO CUSTOMER VALUES('10013','Olowski','Paul','F','615','894-2180','536.75'); INSERT INTO CUSTOMER VALUES('10014','Orlando','Myron','','615','222-1672','0'); INSERT INTO CUSTOMER VALUES('10015','O''Brian','Amy','B','713','442-3381','0'); INSERT INTO CUSTOMER VALUES('10016','Brown','James','G','615','297-1228','221.19'); INSERT INTO CUSTOMER…
Create table queries CREATE TABLE Students( StudentID INT NOT NULL PRIMARY KEY, LastName VARCHAR(25) NOt NULL, FirstName VARCHAR(25) NOT NULL, EnrollmentDate DateTime2(0) NOt NULL, GraduationDate Date NULL) CREATE TABLE Courses( CourseID INT NOT NULL PRIMARY KEY, CourseNumber INT NULL, CourseDescription VARCHAR(50) NOT NULL, CourseUnits INT NOT NULL, DepartMentID INT NOT NULL, InstructorID INT NOT NULL) CREATE TABLE StudentCourses( StudentID INT NOT NULL, CourseID INT NOT NULL, PRIMARY KEY(StudentID, CourseID), FOREIGN KEY (StudentID) REFERENCES Students(StudentID), FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)) CREATE TABLE Tuition( PartTimeCost SMALLMONEY NOT NULL, FullTimeCost SMALLMONEY NOT NULL, PerUnitCost SMALLMONEY NOT NULL) arrow_forward Step 3 CREATE FUNCTION fnStudentUnits( @studentID INT)RETURNS INTASBEGIN -- Declare the return variable here DECLARE @totalUnits INT SET @totalUnits = 0 SELECT @totalUnits =…
Add two columns to the EMPLOYEES table. One column, named EmpDate, contains thedate of employment for each employee, and its default value should be the system date. Thesecond column, named EndDate, contains employees’ date of termination. When I put this formal it says, line 2 has invalid identifier! Can you help me what I need to fix from line 2? alter table EMPLOYEES2add column EmpDate date = getdate(),add column EndDate;
CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT NULL,donor_age int,PRIMARY KEY (donor_id ));CREATE TABLE DONATIONS(pledge_id INT NOT NULL,pledge_date varchar(255) NOT NULL,amount_pledged int,Is_paid int,donor_id int,PRIMARY KEY (pledge_id ),FOREIGN KEY (donor_id) REFERENCES DONORS(donor_id)); 1. Populate every relation with three rows.
Write a SELECT statement that joins the Instructors and Courses tables and returns these columns: LastName, FirstName, and CourseDescription. Return at least one row for each instructor, even if that instructor isn’t teaching any courses. Sort the result set by LastName and then by FirstName in ascending order.
WEEK 3 ASSIGNMENT This assignment contains two parts. You must complete Part I before moving on to Part II. Part I: Using the table you previously worked on, complete the following exercise: Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns. Select a row from your student table where the last name equals "Parker". Select a row from your student table where the ZIP code is less than "68134". Select the student first and last name from the student table order by the state column. Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your…
Use LargeCO tables to complete this assignment. Write a stored procedure that adds a new employee to lgemployee table. Pass the field values to the procedure as parameters.Use parameters and a DECLARE statement to display employees that were hired in every decade beginning 1970. The program should return the statements similar to this:12 employees were hired between 1970 and 198019 employees were hired between 1980 and 1990etc. LageCo Table Code: CREATE TABLE lgbrand (brand_id numeric(4,0) NULL,brand_name VARCHAR(100) NULL,brand_type VARCHAR(20) NULL); CREATE TABLE lgproduct (prod_sku VARCHAR(15) NOT NULL,prod_descript VARCHAR(255) NULL,prod_type VARCHAR(255) NULL,prod_base VARCHAR(255) NULL,prod_category VARCHAR(255) NULL,prod_price NUMERIC(10,2) NULL,prod_qoh NUMERIC(10,0) NULL,prod_min NUMERIC(10,0) NULL,brand_id NUMERIC(4,0) NULL); CREATE TABLE lgvendor (vend_id NUMERIC(6,0) NOT NULL,vend_name VARCHAR(255) NULL,vend_street VARCHAR(50) NULL,vend_city VARCHAR(50) NULL,vend_state…