Geeks Talk

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 ...

Go Back   Geeks Talk > Enterprise Solutions > Oracle Apps
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read
  #1 (permalink)  
Old 08-10-2007
Junior Member
 
Join Date: Aug 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
sahanai mishra is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 08-11-2007
Junior Member
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
csharp.prem is on a distinguished road
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:
Originally Posted by sahanai mishra View Post
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
Reply With Quote
Reply

  Geeks Talk > Enterprise Solutions > Oracle Apps

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved