In my table i'm having the duplicate records with sequence
number and my requirement is when in new record is coming i
want to delete existing old record(onlyone i.e maintaing the
partial duplicate date )and add new record
- 2 Answers
- 4933 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / premnathselvaraj
selet distinct column name
from table
| Is This Answer Correct ? | 5 Yes | 14 No |
Explain an ORA-01555
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is cardinality?
How client makes connection with server in client/server architecture?
which one is currently in used software cmpanies.
Could you please let me know the interfaces in OM / FA??
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
What view would you use to look at the size of a data file?
difference of using cursor for loop and open,fetch,close.which one is better
What view would you use to determine free space in a tablespace?
Can We Restore a Table that accidantly dropped.
Oracle General 
