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 / monty

if you have a table employee you can create duplicate
record using into statement

select *into backup_employee from employee

the above statement create new table backup_employee with
same data of employee

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the acid properties and explain?

939


what happens if you no create privilege in a database? : Sql dba

981


What is mutating error?

950


What are user defined functions?

992


how to include character strings in sql statements? : Sql dba

1045


What is the difference between view and stored procedure?

949


Explain unique key in sql.

988


I need a function for a train ticket reservation please answer it thanks in advance

1002


How many databases can sql express handle?

967


What operating systems are supported by oracle sql developer?

937


Why is pl sql used?

963


What are the key differences between SQL and PL SQL?

1198


How do temporal tables work?

937


What is attribute indicator in pl sql?

1000


What are types of exception?

904