Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a script file that performs the following in SQL developer. Insert a statement to drop the CustomerView Insert a statement to create an updatable
Create a script file that performs the following in SQL developer.
Insert a statement to drop the "CustomerView"
Insert a statement to create an updatable view, "CustomerView" based on the "Customer" table that retrieves all fields of the customer table.
Insert at least 5 new customers
COLUMN NAME DATA TYPE 1 CUSTID 2 NAME 3 ADDRESS 4 CITY 5 STATE 6 ZIP 7 AREA 8 PHONE 9 REPID NUMBER (6,0) VARCHAR2 (45 BYTE) Yes VARCHAR2 (40 BYTE) Yes VARCHAR2 (30 BYTE) Yes VARCHAR2 (2 BYTE) Yes VARCHAR2 (9 BYTE) Yes NUMBER (3,0) VARCHAR2 (9 BYTE) Yes NUMBER (4,0) NUMBER (9,2) LONG NULLABLE DATA-DEFAULT | COLUMN-ID C 1 (nu 2 (nu 3 (nu 4 (nu 5 (nu 6 (nu 7(nu 8 (nu 9 (nu 10 (nu 11 (nu (null) (null) (null) (null) (null) (null) (null) (null) (null) (nul (null) No Tes 10 CREDITLIMIT 11 CoMMENTS No Tes TesStep 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