Register

UNDER keyword in SQL

1,231 views
0 votes
0 votes
UNDER keyword in SQL is used to define

a)subtype

b)grouping of 2 tables

c)union of two tables

d)intersection of 2 tables
User Avatar

1 Answer

Best answer
2 votes
2 votes

Subtypes are created using the keyword UNDER as follows

CREATE TYPE student_typ UNDER person_typ

A subtype inherits the following:

  • All the attributes declared in or inherited by the supertype.

  • Any methods declared in or inherited by supertype.

Example: https://docs.oracle.com/cd/B28359_01/appdev.111/b28371/adobjbas.htm#BCFIEIFE

• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

7 votes
7 votes
1 answer
1
Chhotu asked Dec 24, 2017
1,529 views
SQL keyword ANY and ALL
Hi Guys, In SQL, <condition> ALL evaluates to TRUE if inner query returns no tuples. { X < ALL (empty) == TRUE } <condition> ANY evaluates to FALSE if inner query returns no tuples. { X < ANY (empty) == FALSE } But what is the logical reason behind this ? PS: ping @Krish__, @Anu007, @Ashwin Kulkarni @reena_kandari and @srestha ji.
Hi Guys,In SQL, <condition ALL evaluates to TRUE if inner query returns no tuples. { X < ALL (empty) == TRUE }<condition ANY evaluates to FALSE if inner query returns no...
User Avatar
1 votes
1 votes
2 answers
3
gari asked Jan 18, 2018
1,239 views
TEST SERIES ( ALL Keyword)
what will be the output(how many tupples)
what will be the output(how many tupples)
User Avatar
Link Copied!