Answered step by step
Verified Expert Solution
Link Copied!

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 customersimage text in transcribed

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 Tes

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_2

Step: 3

blur-text-image_3

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 2 Lnai 9285

Authors: Annalisa Appice ,Pedro Pereira Rodrigues ,Vitor Santos Costa ,Joao Gama ,Alipio Jorge ,Carlos Soares

1st Edition

3319235249, 978-3319235240

More Books

Students also viewed these Databases questions