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

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  


i have marks in table,how to find total?

1 Answers  


Can We Restore a Table that accidantly dropped.

8 Answers   TCS,


What is the difference between recovery and restoring of the oracle database?

0 Answers  


How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,


How do you switch from an init.ora file to a spfile?

1 Answers   HCL, Wipro,


What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers  


Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 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)