Monday, 20 July 2015

WHAT IS DIFFERENCE BETWEEN WHERE CLAUSE AND HAVING CLAUSE ?

WHERE                                                                                                                 HAVING
=================================               ================================
1. WHERE CLAUSE RESTRICT THE ROWS        1.HAVING CLAUSE RESTRICT THE ROWS
RETURNED BY THE SINGLE ROW FUNCT           RETURNED BY THE GROUP FUNCTIONS.
TIONS.

2.WHERE CLAUSE SHOULD APPEAR                 2.HAVING CLAUSE SHOULD APPEAR
BEFORE GROUP BY CLAUSE.                                  AFTER GROUP BY CLAUSE.

No comments:

Post a Comment

How to schedule PO workflow schedule process

create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS    --|==========================================================================...