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
Answer Posted / premnathselvaraj
selet distinct column name
from table
| Is This Answer Correct ? | 5 Yes | 14 No |
Post New Answer View All Answers
can u give guidance abt packages of plsql
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What is autocashrule set? : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
how to write customizations in po
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Where in the Oracle directory tree structure are audit traces placed?
Could you please let me know the interfaces in OM / FA??
key flexfield structure
What is auto invoicing? Explain : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation