what is difference between where clause and having clause?
- 13 Answers
- 33005 Views
- I also Faced
- E-Mail Answers
Answer Posted / pawan
HAVING clause is used only with GROUP functions whereas
WHERE clause we can use with both.
| Is This Answer Correct ? | 8 Yes | 15 No |
Post New Answer View All Answers
How to add a new column to an existing table with a default value?
How do we represent comments in oracle?
What is the usage of control file in oracle?
What are advantages of dateset in datastage?
What is Segment Advisor in Oracle?
How do I spool in oracle?
What is a system tablespace and when it is created?
How to import one table back from a dump file?
How to connect to oracle using service name instead of sid?
What are the different types of partitions in oracle?
How to divide query output into groups in oracle?
What is primefaces used for?
How to delete a column in an existing table in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is the parameter mode that can be passed to a procedure?
