• 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:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 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...

    ITKE351,865 pointsBadges:
  • What’s the easiest way to test an Oracle stored procedure?

    We've been working on an ASP.NET project that's using an Oracle database. We've been using TOAD to add and manage stored procedures. This is where the problem lies....we're having too much trouble testing an Oracle stored procedure. Here's an example of one of our stored procedures: CREATE OR...

    ITKE351,865 pointsBadges:
  • Oracle licensing: I need the documents related with the file F0092

    Needs to identify named users in JDE World and One World to ensure compliance with Oracle Licenses. A user may have multiple profiles in multiple environments which in Oracle's eyes would be counted as one named user We are looking at using the following fields to capture a unique identifier that...

    Bhuvanendar5 pointsBadges:
  • COMMUNITY ANNOUNCEMENT: Tell us your Data Center Tales and you could win a Nintendo Wii

    Tell us your Data Center Tales and you could win a Nintendo Wii We want to hear your stories or see pictures of your craziest data centers. Your contest submissions will be published on the Tales from the Data Center blog for all to read. This two-month long contest (Oct-Nov) is your chance to win...

    ITKE351,865 pointsBadges:
  • Oracle RR Date Format

    Can anyone tell me about RR Date format in Oracle 9i (SQL)?

    JOGENDER20095 pointsBadges:
  • A framework compatible with Oracle 10g

    Please I need a .NET framewoork compatible with Oracle 10g.

    Tchywallace220 pointsBadges:
  • Should I do SAP or Oracle for my education background?

    Hi all, I'm Priyanka persuade betech (ECE), MBA (finance, HR). I'm currently working. I'm interested to learn SAP FICO. Can you please suggest doing SAP is best or Oracle for my education background?

    skpriyanka45 pointsBadges:
  • Compare values in same column in Oracle PL/SQL

    I have a set of data in table. For example, let my data be: id         col1 ------------- 1          a 2           b 3           c 4            d 5           a 6            b 7            e 8            f...

    usoracle5 pointsBadges:
  • Build relationship between two tables from different Oracle databases

    Can I build a relationship between two tables from different Oracle databases?

    hahamama5 pointsBadges:
  • ORA-01000: maximum open cursors exceeded

    I'm getting the ORA-01000: maximum open cursors exceeded in one XML. How do I resolve this? All result set and statements are closed in finally block.

    Nikhitasuresh5 pointsBadges:
  • Converting and deploying 6i Forms to Forms 10g

    I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that's true, then how do I run them? Is there a runtime with 10g? I feel like an idiot,...

    Herbiebill35 pointsBadges:
  • Oracle opportunities

    I completed my B.E in 2009, so I want interested to go to Oracle side, so I know the concept of SQL and PL/SQL. Relating to this I dont have a project of this. So please give me some titles of project at least I can go through this. Regards.

    Ingalagi5 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