Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started