Questions & Answers

  • How to call trigger stored in database using Oracle Forms

    how to call trigger stored in database using oracle forms

    RoseForHeba5 pointsBadges:
  • How can I call a trigger in a SQL Server stored procedure?

    How can I call a trigger in a SQL Server stored procedure?

    SQL Server Ask the Experts2,585 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...

    ITKE352,395 pointsBadges:
  • SQL Server Query

    How to find the second highest value in a table using a Query. For example, in a table of employees how to find the second highest salaried employee.

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

    ITKE352,395 pointsBadges:
  • Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Sameera5 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • SQL question

    One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000    ...

    Hema19865 pointsBadges:
  • User profile cannot be loaded on my PC

    How to solve to my PC question. My user profile cannot be loaded. What should I do?

    Ariful1115 pointsBadges:
  • ActiveSync/Mail for Exchange : Display name not sync with gal

    SBS 2003 (Exchange 2003 sp2) Hi, I installed an SBS 2003 and all work fine. Now, I have 2 smartphone: 1 nokia and 1 htc (wm6.1) For nokia I use Mail for Exchange to synchronise mails, contacts and calendar For htc, I use ActiveSync. All sync works fine *** but *** I have 1 issue: * I defined some...

    Jmiranda75 pointsBadges:
  • Batch File for displaying popup window with a message

    Please a simple batch file for displaying a popup window with a message Thanks

    Jjjjjjjj95 pointsBadges:
  • Linking Crystal Reports

    Open Report - No Saved Data This report file does not contain saved data and cannot be viewed. New install of CR 2008 viewing report over vender database. How do I link data to reports I write?

    NIK11115 pointsBadges:
  • Database Views in SQL Server

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

    Jwcurrier30 pointsBadges:
  • How to create tasks in Exchange Web Services MAPI

    I'm pretty new to EWS MAPI and I'm having some difficulty with how to create and managed tasks. I've figured out how to create a task for myself with a problem but here's where I'm stuck. I can't create a task and assign it to another user. Can't interrogate the status of the task (percent...

    ITKE352,395 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to extract data from SAP APO to BW (Not APO’s)

    Hi all, The APO system has many data sources. I have activated all the datasource with TCODE RSA5. I want to extract APO data to BW (Not APO's),where the APO data come from for BW extract. APO BW? SAP transparent table of APO? APO liveCache? Please help me. Thank you very much.

    BwConsultant10 pointsBadges:
  • i have a Exchange server 2003, and for some reason the public folder store has dismounted. However when i try to mount it i get the error message

    i have a Exchange server 2003, and for some reason the public folder store has dismounted. However when i try to mount it i get the error message

    Peace5 pointsBadges:
  • Configuring Outlook Anywhere

    Steps required to configure Outlook Anywhere using a single Exchange 2007 server and Outlook 2003 clients

    TheUKITGuy10 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