What will be the output for the below Query
Select 'High' from dual where null = null;
Answer Posted / rapaka srivani
the answer will be "no rows selected" because in question
we used a word called 'dual'. 'dual' is a default table in
SQL where it doesn't contain data. so the answer will
be 'no rows selected'.
| Is This Answer Correct ? | 20 Yes | 23 No |
Post New Answer View All Answers
Why do we create stored procedures & functions in pl/sql and how are they different?
What is the need of merge statement?
How exception handling is done in advance pl/sql?
Define the select into statement.
Which sql most popular?
What are the advantages of normalization?
Is nosql relational?
What is gpt format?
Where is all the data on the internet stored?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How do we accept inputs from user during runtime?
Is a table valued function object?
how does a local variable is defined using t-sql? : Transact sql
what is the difference between truncate and drop statements? : Sql dba
How are functions and procedures called in PL/SQL?