Awesome q2a theme
0 votes
13 views

Query 1 is right and query 2 is wrong right?

Query 2 returns SID who has  NOT supplied every red part right?

ago in Databases by (613 points) | 13 views
0
0

Your understanding of Q2 seems correct.

But I really doubt Q1 will work correctly.

Oracle Documentation - https://oracle-base.com/articles/misc/all-any-some-comparison-conditions-in-sql

 

  • "x = ALL (...)": The value must match all the values in the list to evaluate to TRUE.
  • "x != ALL (...)": The value must not match any values in the list to evaluate to TRUE.
  • "x > ALL (...)": The value must be greater than the biggest value in the list to evaluate to TRUE.
  • "x < ALL (...)": The value must be smaller than the smallest value in the list to evaluate to TRUE.
  • "x >= ALL (...)": The value must be greater than or equal to the biggest value in the list to evaluate to TRUE.
  • "x <= ALL (...)": The value must be smaller than or equal to the smallest value in the list to evaluate to TRUE.

If the Catalog table is being evaluated tuple by tuple, how can one row's Pid be equal to ALL the Pid's returned by the subquery ?

0

If the Catalog table is being evaluated tuple by tuple, how can one row's Pid be equal to ALL the Pid's returned by the subquery ?

Then how in practice ALL command gets executed? In all cases we must only evaluate tupple by tupple right?

0
The segment I pasted above literally explains how ALL works in practice.

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Jan 2020
  1. shashin

    1163 Points

  2. Vimal Patel

    306 Points

  3. Deepakk Poonia (Dee)

    305 Points

  4. Debapaul

    237 Points

  5. Satbir

    192 Points

  6. SuvasishDutta

    137 Points

  7. Pratyush Priyam Kuan

    118 Points

  8. tp21

    108 Points

  9. DukeThunders

    96 Points

  10. pranay562

    95 Points

Monthly Top User and those within 60% of his/her points will get a share of monthly revenue of GO subject to a minimum payout of Rs. 500. Current monthly budget for Top Users is Rs. 75.
2,989 questions
1,509 answers
8,936 comments
89,814 users