Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CREATE TABLE category (catcode VARCHAR2(2), catdesc VARCHAR2(10));Table created.2.CREATE TABLE j_employees (emp# NUMBER(5), lastname VARCHAR2(15), frstnameVARCHAR2(10), job_class VARCHAR2(4));Table created.3.ALTER TABLE j_employees ADD (empdate DATE DEFAULT SYSDATE,

CREATE TABLE category (catcode VARCHAR2(2), catdesc VARCHAR2(10));Table created.2.CREATE TABLE j_employees (emp# NUMBER(5), lastname VARCHAR2(15), frstnameVARCHAR2(10), job_class VARCHAR2(4));Table created.3.ALTER TABLE j_employees ADD (empdate DATE DEFAULT SYSDATE, enddate DATE);Table altered.4.ALTER TABLE j_employees MODIFY job_class VARCHAR2(2);Table altered.5.ALTER TABLE j_employees DROP column enddate;Table altered.6.RENAME j_employees TO jl_emps;Statement processed. (This is where I realized it needed to be j_employees, so I went back to fxeverything. I got ORA-00955: name is already used by an exisng object)7.CREATE TABLE book_pricing (id, cost, retail, category) AS (SELECT isbn, cost, retail, categoryFROM books);Table created.8.ALTER TABLE book_pricing SET UNUSED(category);Table altered.SELECT * FROM book_pricing; (could you just: SELECT category FROM book_pricing; to see i it

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bioinformatics Databases And Systems

Authors: Stanley I. Letovsky

1st Edition

1475784058, 978-1475784053

More Books

Students also viewed these Databases questions

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago

Question

Acceptance of the key role of people in this process of adaptation.

Answered: 1 week ago

Question

preference for well defined job functions;

Answered: 1 week ago