Awesome q2a theme
0 votes
20 views

Query 1 is right and query 2 is wrong right?

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

in Databases by (699 points) | 20 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
Top Users 2020 Aug 10 - 16
  1. Arkaprava

    404 Points

  2. jayeshasawa001

    198 Points

  3. SarathBaswa

    126 Points

  4. Ashutosh777

    67 Points

  5. toxicdesire

    20 Points

  6. Nilabja Sarkar

    12 Points

  7. premu

    10 Points

  8. iarnav

    7 Points

  9. Jhumpa_Sarma

    6 Points

  10. Patel0967

    6 Points

Weekly Top User (excluding moderators) will get free access to GATE Overflow Test Series for GATE 2021
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Aug 2020
  1. Arkaprava

    404 Points

  2. jayeshasawa001

    203 Points

  3. Mellophi

    156 Points

  4. Ashutosh777

    143 Points

  5. SarathBaswa

    126 Points

  6. anurag sharma

    49 Points

  7. toxicdesire

    20 Points

  8. shashankrustagi2021

    16 Points

  9. premu

    16 Points

  10. Kushagra गुप्ता

    15 Points

7,769 questions
1,977 answers
11,275 comments
95,111 users