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
What is the oracle implicit cursor?
What is oracle rowcount?
What is a trigger and what are its types?
What is a sub query? Describe its types?
What are the attributes of cursor?
How to view existing locks on the database?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to create an oracle database manually?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is difference between truncate and delete?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is a data lock in oracle?
What is a package in oracle?
Can you drop an index associated with a unique or primary key constraint?
How to start a new transaction in oracle?