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
Answers were Sorted based on User's Feedback
Answer / premnathselvaraj
selet distinct column name
from table
| Is This Answer Correct ? | 5 Yes | 14 No |
please send me oracle pl/sql exp resume. and also faqs...
What is index? How many types of indexes?
which one is currently in used software cmpanies.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
When creating a user, what permissions must you grant to allow them to connect to the database?
what is diff between pre insert,on insert,post insert triggers?
Explain the difference between a hot backup and a cold backup and the benefits associated with each
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
For web applications from which version of Oracle is suitable?
Differentiate between transaction type and transaction source? : oracle accounts receivable
the user should know to which database he is connected currently in oracle
Explain the use of setting GLOBAL_NAMES equal to TRUE.