Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. lab requires you to use oracle view to implement a

lab requires you to use Oracle VIEW to implement a virtual database on DBSEC schema, for...

60.2K

Verified Solution

Question

Programming

lab requires you to use Oracle VIEW to implement a virtualdatabase on DBSEC schema, for example, on CUSTOMER table. Your taskis to develop a single SQL script that will perform all thefollowing tasks:

Table created for this assignment is listed below:

create table CUSTOMER_VPD(

SALES_REP_ID NUMBER(4),

CUSTOMER_ID NUMBER(8) NOT NULL,

CUSTOMER_SSN VARCHAR(9),

FIRST_NAME VARCHAR(20),

LAST_NAME VARCHAR(20),

ADDR_LINE VARCHAR(40),

CITY VARCHAR(30),

STATE VARCHAR(30),

ZIP_CODE VARCHAR(9),

PHONE VARCHAR(15),

EMAIL VARCHAR(80),

CC_NUMBER VARCHAR(20),

CREDIT_LIMIT NUMBER,

GENDER CHAR(1),

STATUS CHAR(1),

COMMENTS VARCHAR(1025),

USER_NAME VARCHAR(30)

);

Tasks:

Populate the CUSTOMER_VPD table withfour rows of records. Pay attention to the column CTL_UPD_USER,

Create a VIEW named as MY_VIEW todisplay only rows that belong to the logged in user

Grant SELECT and INSERT privilege onMY_VIEW to DBSEC_CLERK

Insert one row of data into MY_VIEW asDBSEC_CLERK by using the following data

Verify your data insertion by queryMY_VIEW. You (as DBSEC_CLERK) should only see one row of data youhave inserted. This signifies the success of yourimplementation.

Answer & Explanation Solved by verified expert
3.5 Ratings (435 Votes)
Below you can find everything clear and feel free to ask any doubts and please dont forget to give upvote as it means a lot Thanks firstly login with DBSEC connect DBSECpassword Task ACreate table customer create table CUSTOMER SALESREPID    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Is it fine to enter double before const in c++? Just like this double const ...

Programming
Q

I need an essay for why sexual offenders should be castrated through the use of pathos,logos,and...

Psychology
Q

You watched the documentary \"Illicit: The Dark Trade\". What in the documentary do you think was...

Psychology
Q

Suppose that Teeny Weeny Airlines (TWA) operates a very small flight from Charleston to Bermuda with...

Statistics
Q

1. Given sample data: 61.2, 61.9, 62.8, 63.1, 64.0, 64.3, 64.9, 65.5, 66.3 and 67.9, test H0:...

Basic Math
Q

could you give a detailed explanation on how you got your answer. Thank you I...

Biology
Q

The frequency of a turning fork A is 2 more than the frequency of a...

Physics
Q

tan 18 tan 18x Simplify your answer including any radicals Use integers or fractions for...

Basic Math
Q

Write interval notation for the given graph 4 10 9 Choose the correct interval OA...

Algebra
Q

Nicole and Braxton are each 50 percent shareholders of NB Corporation. Nicole is also an...

Accounting
Q

do the part b please Question 5 (con't) PART...

Accounting
Q

Joey parked his car on the top of a hill when he went to watch...

Accounting