Question: Inserting values in the object type: CREATE TYPE external_person AS OBJECT ( name VARCHAR2(30), phone VARCHAR2(20) ); CREATE TABLE contacts ( contact external_person udate DATE

Inserting values in the object type: CREATE TYPE external_person AS OBJECT ( name VARCHAR2(30), phone VARCHAR2(20) ); CREATE TABLE contacts ( contact external_person udate DATE ); INSERT INTO contacts VALUES ( external_person (NULL, NULL), '24-Jun -97' ); (1) Create user-defined types as follows: CREATE TYPE location as OBJECT( building_no NUMBER, city VARCHAR2(40) ); CREATE TYPE person as OBJECT( ssno NUMBER, name VARCHAR2(100), address VARCHAR2(100), office location ); CREATE TABLE persons of person; Insert a row into the persons table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

#include using std::string; #ifndef PERSON_H #define PERSON_H 8 class Person private: string firstName; string lastName; string phone; string email; public: Person(); POCOU AWNOO. ONO // getters...

I need help with this lab assignment it must be in python Dave Jeffery will be at a conference on March 16, 2018. Class will meet in ARSC 124 at the normal time to work on Lab 9. Blackboard will...

The Final Project is to develop a simple database system. The database is to handle multiple records, each composed of several fields. The database will store its information to a file, addition and...

For this project, you are going to create the Intercollegiate Athletic Database. More specifically you will have to create the tables described in the Background file and populate the tables with the...

Hands-On Assignments: Lesson 12 Create a view called EMP_VU based on the employee number, employee name, and department number from the EMP table. Change the heading for the employee name to...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number. Modify the...

Oracle 11g PL/SQL question. The tables needed can be created with the c10_BBcreate.sql listed below. Using Dynamic SQL to create a procedure named add_row_sp for inserting a row into a table with...

Today is professor Wang's birthday, and she is planning to save $30000 per year for retirement, with the first deposit to be made today followed by another deposit on each of the next 4 birthdays....

Design a simply supported laterally restrained beam of 4M carrying factored point load of an effective span 4m intensity 50KN mid spon. Design an appromiote section using Feu10 Grode steel.

Question 9 ( 2 points ) Saved The history of financial markets tells us that different classes of financial assets have different return dispersions. Which of the following asset classes typically...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

14-13 Assess the importance of the Unemployment Compensation Modernization System project for the state of Pennsylvania.

14-12 Form a group with three or four other students. Write a description of the implementation problems you might expect to encounter in one of the systems described in the Interactive Sessions or...

After selecting a mortgage, calculate your closing costs and the monthly payment. When you are finished, evaluate the whole process. For example, assess the ease of use of the site and your ability...