Create Table and Migrate Data
<p>I am a newbie to database programming and has a question.</p>

<p>In the C++ application that am working, there's a Oracle DB. One of the table is called USR_INFO. It has multiple columns like,</p>

<pre><code> 1. U_INFO_ID
 2. U_INFO_FIRST_NAME
 3. U_INFO_LAST_NAME
 4. U_INFO_ADDRESS
 5. U_INFO_AGE
 6. U_INFO_LAST_LOGIN_DATE
 7. U_INFO_LAST_LOGIN_TIME
</code></pre>

<p>Now i want to create a new table called USR_LOG_INFO, and add 3 columns to it called,</p>

<pre><code> 1. U_INFO_ID
 2. U_INFO_LAST_LOGIN_DATE
 3. U_INFO_LAST_LOGIN_TIME
</code></pre>

<p>And then migrate the data for same columns from USR_INFO to similar columns in USR_LOG_INFO.</p>

<p>Basically there are 2 steps involved here.</p>

<p>1.Create new table called USR_LOG_INFO</p>

<p>2.Migrate column data from USR_INFO to USR_LOG_INFO</p>

<p>Can somebody give me SQL commands to do above 2 steps?</p>