Attribute Specification in Select Clause



Rating - 3/5
508 views

The asterisk symbol “ * ” can be used in the select clause to denote “all attributes.”
Thus, the use of instructor.* in the select clause of the query:

These Topics Are Also In Your Syllabus
1 Example of Notation- UML Class Diagrams link
2 Relationship Types of Degree Higher than Two link
You May Find Something Very Interesting Here. link
3 Ordering the Display of Tuples link
4 Relationship between Information Security versus Information Privacy link
5 Types Of Systems link

select instructor.*
from instructor, teaches
where instructor.ID= teaches.ID;

These Topics Are Also In Your Syllabus
1 Introduction to Database Security Issues link
2 chapter 11 Object and Object-Relational Databases link
You May Find Something Very Interesting Here. link
3 XML: Extensible Markup Language link
4 Schema Diagrams link
5 Types Of Systems link

indicates that all attributes of instructor are to be selected. A select clause of the
form select * indicates that all attributes of the result relation of the from clause
are selected.

These Topics Are Also In Your Syllabus
1 what is database management system link
2 Database-System Applications link
You May Find Something Very Interesting Here. link
3 Specialization and Generalization link
4 Constraints and Characteristics of Specialization and Generalization Hierarchies link
5 Modeling of UNION Types Using Categories link

Rating - 3/5
538 views

Advertisements
Rating - 3/5