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
How to fetch the row which has the max value for a column?
How to turn on or off recycle bin for the instance?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is oracle rownum?
What do you mean by a database transaction & what all tcl statements are available in oracle?
State any two functions of oracle?
What is the difference between translate and replace in oracle?
What is the sid in oracle?
Explain the features of oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is a lookup table in oracle?
What is an oracle data file?
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.
How can we create the complete backup of data in the oracle.