Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 19190 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anitha
select * from emp where null=null: will not return any rows
in the table since two null values are not always same.
select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.
| Is This Answer Correct ? | 36 Yes | 1 No |
Answer / anee desai
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.if 2=2 will also provide the same
result.it makes no sense in writing 1=1;
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / shree
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / raj
Null=Null returns no row but 1=1 returns entire row of the
table.
| Is This Answer Correct ? | 2 Yes | 0 No |
select*from emp where null=null;
this command will not return any record bcoz the
condition null=null false as two null values are not equal.
select*from emp where 1=1;
will return all the records present in the table emp as
the condition 1=1 is always true.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandana
NULL = NULL ...NOT TRUE
NO ROWS RETURNED
1=1 ...TRUE
ALL ROWS RETURNED
1=2....NOT TRUE
NO ROWS RETURNED
2=2,3==3 AND SO ON WILL RETURN ALL ROWS FROM A TABLE
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bhavish
1.statament "no rows select"
2.statament "the 14 rows displayed
why because the true condition and null values are different
| Is This Answer Correct ? | 0 Yes | 0 No |
How to resolve name conflicts between variables and columns?
What are steps required to ENTER DATA INTO DWH?
What happens if you set the sga too low in oracle?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What privilege is needed for a user to query tables in another schema?
How to create a table interactively?
What is oracle rowcount?
What is connection pool in oracle?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
Oracle General 
