[GENERAL] select from dynamic table names

2011-11-10 Thread Dinesh Kumara
('2011-11-10')from 1 for 1)) but it is giving an error that is error with '||' appender. please someone give me an idea.. -- Thanks and Regards, Dinesh Kumara, Software Engineer, Reservation Gateway Inc, Email:din...@rezgateway.com www.rezgateway.com

[GENERAL] Cursor loop - stop current iteration and continue with next iteration

2011-12-21 Thread Dinesh Kumara
h next iteration.]        ELSE         ...         More  logic s here...         ...         END IF;     END LOOP; CLOSE rec_contractlist; ... Really appreciate if you can help me on this. -- Thanks and Regards, Dinesh Kumara, Software Engineer, Reservation Gateway Inc, Email:din..