There is a big table with "n" of rows and 40 + columns .It
doesn't have primary key.How do you select the primary key.
In other words how do you get the duplicate records.
Answer Posted / nithin
Hi
I could possibly think of only one solution without using
group by clause.
create table emp_bkp as select distinct * from employee
drop table employee
rename emp_bkp to employee
Let me know if there is any other possible answer
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to convert a string to a date in oracle database?
What is a table in oracle?
How to experiment a data lock in oracle?
What are nested tables?
How to view existing locks on the database?
Is oracle a relational database?
How to test null values?
How to store pictures on to the database?
Explain what are the different type of segments?
How to define a variable of a specific record type?
Explain the blob datatype?
How to use "for" statements in oracle?
Does oracle partitioning improve performance?
How to define a data source name (dsn) in odbc manager?
What is bind variable in oracle 11g?