Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



In my table i'm having the duplicate records with sequence number and my requirement is when ..

Answer / guest

del recold
enter new rec

Is This Answer Correct ?    1 Yes 9 No

In my table i'm having the duplicate records with sequence number and my requirement is when ..

Answer / premnathselvaraj

selet distinct column name
from table

Is This Answer Correct ?    5 Yes 14 No

Post New Answer

More Oracle AllOther Interview Questions

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,


i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,


What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,


Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,


How to find locks exists in a table or not?

1 Answers   HCL,


can we drop dual table

7 Answers   Metric Stream,


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers   Infosys,


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,


the user should know to which database he is connected currently in oracle

3 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  


what is sql*loader parameters and where we will use it.

1 Answers   Accenture,


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

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)