>create table table_name2 as select * from table

what eliminate duplicate without using roenum and not

Question Posted / amar_kondla

Answer Posted / amar_kondla

>create table table_name2 as select * from table_name1;

>drop table table_name1;

> rename tabale_name2 to table_name1;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain the select statement in sql?

1100

What is a database event trigger?

1145

Does sqlite need a server?

1040

Explain dml and ddl?

974

What is minus?

981

What does the base_object_type column shows in the user.triggers data dictionary view?

1035

Why use truncate instead of delete?

999

Do ddl statements need commit?

961

Can we create a trigger on view?

887

What is the cause of mutating table error and how can we solve it?

1041

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1098

What is AUTH_ID and AUTH_USER in pl/sql ?

2177

what are the 'mysql' command line options? : Sql dba

1066

what is cross join? : Sql dba

988

How to change the order of columns in Oracle SQL Plus ?

1047