Monthly Archives: June 2015

Oracle: Steps to Install Dumps on Local Database

All Users have the oracleXE in our local machine, sometime we need to import the dump for Projects in local machine. We need to follow these steps to import the dump in our local machine : Step 1: Connect with the system user from cmd prompt. sqlplus user/password@XE as sysdba; Step 2 (optional): For some Project we […]

Hibernate criteria IN clause: List size more than 1000 values

If list size is more than 1000 values in IN CLAUSE then it throws below oracle error: Error : ORA-01795: maximum number of expressions in a list is 1000 Oracle does not allow more than 1000 parameter values in a IN clause.  Avoiding Error By Oracle : You could use one of the workarounds i.e. By […]