what is the output of select * from emp where null=null &
select * from emp where 1=1

Answer Posted / kumar

Really Good Answer Anitha Madam.

By
Kumar.T

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I escape a reserved word in oracle?

624


How to load data through external tables?

581


What is system global area (sga) in oracle?

571


How to define a data field as not null?

631


How can Oracle users be audited?

601






what is the difference between restoring and recovering?

553


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1468


How to add a new column to an existing table with a default value?

542


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1572


Why we use bulk collect in oracle?

532


What are the different types of failures that occur in Oracle database?

594


How to define an anonymous procedure with variables?

543


How to invoke the data pump import utility?

648


Who developed oracle & when?

566


In the oracle version 9.3.0.5.0, what does each number shows?

746