Review on Overview of Oracle Operators
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2017, Vol 5, Issue 4
Abstract
SQL set operators allows combine results from two or more SELECT statements. At first sight this looks similar to SQL joins although there is big difference. SQL joins tends to combine columns i.e. with each additionally joined table it is possible to select more and more columns. You can combine multiple queries using the set operators UNION, UNION ALL, INTERSECT, and MINUS. All set operators have equal precedence. If a SQL statement contains multiple set operators, Oracle evaluates them from the left to right if no parentheses explicitly specify another order.
Authors and Affiliations
Husandeep Kaur, Jasmeet Kaur, Deepak Mittal, Ramandeep Kaur
Keywords
Related Articles
- EP ID EP23936
- DOI http://doi.org/10.22214/ijraset.2017.4230
- Views 303
- Downloads 10
Crack detection and crack propagation through vibration monitoring in sugar mill roller shaft
The effects of vibration in mill roller shaft during sugar cane crushing which is one of the crack possibility phenomena were analysed. Inducer tests under various unbalanced conditions performed to clarify the effect o...
A Review on Comparison of Ancient and Modern Construction Materials in Civil Engineering
There is a vast difference between the construction materials used by Civil Engineers in ancient times and recent times. Earlier the use of waste materials in the construction projects are not preferred but nowadays the...
In-vitro Antioxidative Property of Water Soluble Bacterial Melanin and Evaluation on Novel Model System
Melanin is important because it’s the most primitive and universal pigment in living organisms. The present study reports antioxidant activity of melanin pigment from EP83 a Gram negative bacterial strain isolated from...
Microstructure study on cement mortar using green sand and copper slag – A review
This paper deals micro structure of cement mortar with green sand and copper slag as replacement of fine aggregate. The replacement of green sand and copper slag will be gradually from 10%, 20%, and 30% by the weight of...
Digital Watermarking on Multimedia Application
This paper incorporates the detail investigation of Digital watermarking clarification, idea and the principle commitments in this field, for example, classes of watermarking procedure that show which watermarking techn...