• Getting duplicate records

    I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records. Our requirement is to find both (or multiple) duplicate records from a table. We are using Oracle 9i. Regards

    PRASAD550 pointsBadges:
  • To delete the duplicate record from Oracle table.

    How do I delete the duplicate a record from an Oracle table? Please provide the command.

    Least5 pointsBadges:
  • Difference between ATG Dynamo and ATG commerce

    What is the difference between ATG dynamo & ATG commerce?

    prithvir5 pointsBadges:
  • Oracle Spatial certification

    What is the learning path of Oracle Spatial. How can I get certificated?

    Balkanay5 pointsBadges:
  • I know SQL, should I learn Oracle database?

    I know SQL but I'm not master in that. I know only basics of SQL. Can I start to study Oracle database directly? If so please suggest me some good way to learn.

    Prcvjr220 pointsBadges:
  • MySQL vs. Oracle

    what is the major two comparison of mysql5.0 and oracle 10g?

    Mysql10 pointsBadges:
  • Oracle application server

    I have a question: Can anyone tell me if that the fusion middle ware is the new name of Oracle application server? Is this fusion middle ware is some new thing?

    Zaeemabrar5 pointsBadges:
  • can VS 2005 support Oracle 10g?

    can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

    KPL5 pointsBadges:
  • Upgrade database & run application Oracle 6i under the web

    What are the steps I can follow to upgrade database engine 8i.1.7 .0.0 to 10g 2 and what is the needed fixes to get 6i developer run on engine 10g? How can I run it 6i developer on 8i through web? I'm running oracle under windows 2003 R2, how can I  utilize memory without limit on windows 32 bit?

    10g5 pointsBadges:
  • How to remove duplicate rows from an Oracle table

    I've been doing some testing in Oracle and just populated a table with some sample data. But, by accident, I loaded several duplicate records into as well so I can't create a primary key using some of the columns. Is there a way for me to delete all the duplicate rows and leave just one of them?

    ITKE352,420 pointsBadges:
  • Calculate time difference with Oracle 9i

    I want to calculate difference between current time and time which is stored in table. How will I calculate the difference between 2 time? After calculating this difference, if this difference is greater than 3 hrs my system should generate an email to technical head. How do I do this? Shall I go...

    Firasha25 pointsBadges:
  • Calling an Oracle stored procedure from SQL Server

    Is it possible to call an Oracle stored procedure from SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Solve TNS-12502 error

    How to solve TNS-12502 error?

    MITI5 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE352,420 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • What is the Oracle Application Object Library?

    What is object library in an Oracle application?

    Nomanjahangirbutt5 pointsBadges:
  • How to save the exported Excel files from Oracle Forms 6

    Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

    Rajanoracle10 pointsBadges:
  • How to config report server to run report by Oracle developer 9i?

    How do I configure an Oracle report server so that it runs a report by Oracle Developer 9i?

    Rkon725 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following