Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
How to insert data from one table to an empty table
This is a discussion on How to insert data from one table to an empty table within the Oracle Apps forums, part of the Enterprise Solutions category; How will you create one table (target table) from another table (source table). The target table should be empty after creation. How to insert data from one table to an ...
|
|||||||
08-10-2007
|
|||
|
|||
|
How to insert data from one table to an empty table
How will you create one table (target table) from another table (source table). The target table should be empty after creation.
How to insert data from one table to an empty table 
|
| Sponsored Links |
|
08-11-2007
|
|||
|
|||
|
Re: How to insert data from one table to an empty table
try this
create table targetTableName [(columnname,columnname)] as select columnname,columnname from sourcetablename where 1 = 2 this will create a target table without taking any record. Now to enter data from one table to another insert into newtablename select columnname,columnname from oldtablename Quote:
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| insert picture to table | rashinkar | Oracle | 9 | 04-25-2009 11:53 AM |
| Add a new column to a table and insert values | Ajit Kumar Maharatha | Oracle | 11 | 12-12-2008 10:58 AM |
| Syntax to insert data in the table | Geek_Guest | Data Warehousing | 6 | 09-18-2007 01:38 AM |
| Is it possible to insert a recode into fact table | Geek_Guest | Data Warehousing | 1 | 09-04-2007 07:53 AM |
| How a java table be brought to data table? | dhandhan | QTP | 0 | 04-15-2007 06:14 AM |
All times are GMT -4. The time now is 04:09 PM.
