test.txt 804 Bytes
 <plugin>
		        <groupId>org.apache.maven.plugins</groupId>
		        <artifactId>maven-surefire-plugin</artifactId>
		        <version>2.18.1</version>
		        <configuration>
		          <skipTests>true</skipTests>
		        </configuration>
		      </plugin>
		      
		      currentpolicyaddress
		      
		      ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
		      
		      
		      
		      
		      select po.branch_code,rpsi.* from rn_policy_service_info rpsi,policy po,branch_code_relation bcr,policy_prem_info ppi
where rpsi.policy_no=po.policy_no
and rpsi.policy_no=ppi.policy_no
and bcr.branch_code=po.branch_code
and bcr.relative_grade>-1
and bcr.relative_branch_code = '864200'
and ppi.PREM_DUE_DATE>=date'2018-01-01'
and ppi.PREM_DUE_DATE<=date'2018-01-30'