• 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?

    ITKE1,000,530 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.

    ITKE1,000,530 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:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Generate an Oracle query

    How to I generate a query that would display the various job_ids, the sum of salaries, average salaries, minimum salary, maximum salary and the number of people in each job_id?

    berknernice27135 pointsBadges:
  • Running Oracle reports 10g as pdf from a form

    I have a report which consists of 2 pages to be printed on pre-printed stationery. When I run the report straight from the report builder,it prints perfectly. But when I print it as pdf from a form(button), the 2page report shows as 248 pages and pages keep getting ejected unless I specify each...

    GOWRI5 pointsBadges:
  • How I will find the duplicate rows count from employee table in Oracle 9i

    How can I find the duplicate rows count from employee table in Oracle 9i?

    gettosrinivas35 pointsBadges:
  • How to call trigger stored in database using Oracle Forms

    how to call trigger stored in database using oracle forms

    RoseForHeba5 pointsBadges:
  • How to find duplicate records in an Oracle table

    How do I find duplicate records in a table?

    gettosrinivas35 pointsBadges:
  • Call Oracle Store Procedure from Reporting services

    Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple: CREATE OR REPLACE PROCEDURE GetReportData ( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )

    PramodSR35 pointsBadges:
  • Calling an Oracle stored procedure in Java

    In my Oracle database, I have this stored procedure: procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor ) Here's what the IDS_TABLE means: create or replace type IDS_TABLE as table of IDS create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER ) Would it be possible for...

    ITKE1,000,530 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.

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

Following