Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to copy a table in another table with datas?

Answer Posted / kavitha nedigunta

create table new_table as select * from old_table;

EG:- create table emp1 as select * from emp;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is java sql drivermanager?

1159


How to place comments in pl/sql?

1215


What is a common use of group by in sql?

1094


Differentiate between syntax and runtime errors.

1235


What is the use of desc in sql?

1017


What is crud diagram?

989


Can two tables have same primary key?

1022


What is sqlerrd?

1013


What is delimiter in pl sql?

1097


What are the two different parts of the pl/sql packages?

1138


How many primary keys can a table have?

1052


What do you understand by exception handling in pl/sql?

1085


What is duration in sql profiler trace?

1140


Can procedure in package be overloaded?

1138


What is rank function in sql?

1068