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 |
how to display last 5 letters from a name (take emp table ename )
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
What is difference b/w Credit memo and Adjustment in AR.
Explain the difference between a data block, an extent and a segment.
How to find locks exists in a table or not?
can we drop dual table
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
the user should know to which database he is connected currently in oracle
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
what is sql*loader parameters and where we will use it.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha