what is difference between where clause and having clause?
Answer Posted / shashikant
in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )
| Is This Answer Correct ? | 44 Yes | 5 No |
Post New Answer View All Answers
What are the differences between blob and clob in oracle?
What is the difference between online and offline backups?
Point out the difference between user tables and data dictionary?
List the parts of a database trigger.
What is meant by joins?
What are the different oracle database objects?
What is the usage of save points in oracle database?
How to assign values to variables?
What is a user account in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to install oracle odbc drivers?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is integrity and what is constraint??Explain with example
How to assign a table row to a record variable?
What is the database name in oracle?