Hello, My project has some requirement to create temp table. I need to perform some operation on temp table like: - 1. Create table 2. Insert some data 3. Perform some operation on that data and update same. 4. Get that data from temp table. I am able to perform all the operations while writing all queries in single statement, my sql mapper file look like this see below: - <sqlMap namespace="xxx" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <select...
Hello, My project has some requirement to create temp table. I need to perform some operation on temp table like: - 1. Create table 2. Insert some data 3. Perform some operation on that data and update same. 4. Get that data from temp table. I am able to perform all the operations while writing all queries in single statement, my sql mapper file look like this see below: - <sqlMap namespace="xxx" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <select...
Hello, My project has some requirement to create temp table. I need to perform some operation on temp table like: - 1. Create table 2. Insert some data 3. Perform some operation on that data and update same. 4. Get that data from temp table. I am able to perform all the operations while writing all queries in single statement, my sql mapper file look like this see below: - <sqlMap namespace="xxx" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <select...
Hello, My project has some requirement to create temp table. I need to perform some operation on temp table like: - 1. Create table 2. Insert some data 3. Perform some operation on that data and update same. 4. Get that data from temp table. I am able to perform all the operations while writing all queries in single statement, my sql mapper file look like this see below: - <sqlMap namespace="xxx" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <select...