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 can I create a table from another table without copying
any values from the old table?

Answer Posted / tejas wajge

create table emp as select * from project where rownum <1;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the nonstandard string types? : Sql dba

1138


How to prepare for oracle pl sql certification?

1066


What is trigger point?

996


what is clause? : Sql dba

1063


Is pl sql useful?

994


What are the sql aggregate functions?

1133


What is keys and its types?

1075


What is trigger in pl sql?

1002


Why we use triggers in mysql?

992


Why is partition used in sql?

1123


How to run pl sql program in mysql?

1020


What are local and global Indexes and where they are useful.

1444


What are secondary keys?

971


What is not null in sql?

1057


Write a sql query to get the third highest salary of an employee from employee_table?

1073