What are the logical operations?
- 1 Answers
- 1203 Views
- I also Faced
- E-Mail Answers
Answer / Vikas
The logical operations in Oracle SQL include NOT, AND, OR, and XOR. NOT reverses the truth value of an expression (i.e., NOT TRUE becomes FALSE and NOT FALSE becomes TRUE). AND returns TRUE if both expressions are TRUE, otherwise it returns FALSE. OR returns TRUE if at least one expression is TRUE, otherwise it returns FALSE. XOR returns TRUE if exactly one expression is TRUE, otherwise it returns FALSE.
| Is This Answer Correct ? | 0 Yes | 0 No |
1.display list of all users from ur data base.what is the query?
what are Triggers?
Why required to run root.sh at the time of installation and what exactly it will do
how to truncate date and get only time part 9:20:00
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
what is primary key and foreign key when and where have to use
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
What is the difference between translate and replace?
When do we use group by clause in a sql query?
How to run create database statement again?
How to declare a local variable?
Oracle General 
