Create table using the existing tables
Example code for dynamically creating table using the tables existing:
CREATE TABLE HIP_TASK_INFO_satish as SELECT HIP_TASK_ID , HIP_TASK_ID as HIP_TASK_BUDGET_ID, HIP_TASK_ID as HIP_DUTY_DETAIL_ID, IS_ACTIVE, IS_DELETE, ADDDT FROM HIP_TASK_INFO
Categories: Oracle