• How do I concatonate the data from the same field from multiple rows

    I need to concatonate data from the same field with multiple rows with a one to many relationship. For example: oder_id product 503 corn 503 beans 503 Apples the end result wanted would be a single row order._id products 503 corn, beans, apples

    Linus665 pointsBadges:
  • How to display non existent data as 0 in Oracle

    in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so...

    Deb4u50 pointsBadges:
  • CPU processor information on my virtual machine

    I'm using a a C# code to find processor information. My Management "Processorld" is null if I run my application on a VM. I'm using Oracle VM VirtualBox for my virtual PC. Here's the code I'm using: System.Management.ManagementClass Management = new...

    ITKE62,120 pointsBadges:
  • Oracle Application Express 11g xe

    I have Oracle Application Express 11g xe installed and when I attempt to create a workspace (PM) I get a error saying invalid or restricted workspace. I am not sure as to how to fix this. I and cannot find the solution. Can anyone give me some instruction or directions. Thank You Steve Walker

    swa775 pointsBadges:
  • Oracle 10g – WEB.SHOW_DOCUMENT parameters

    What other parameters can be used with WEB.SHOW_DOCUMENT besides '_BLANK'?

    jkeri355 pointsBadges:
  • Oracle Forms 6i – “when timer expired”

    I don't know the logic of "When Timer Expired" trigger in forms 6i. Can someone please explain it (with examples)?

    SuperRad40 pointsBadges:
  • How to uninstall Oracle Virtual Box

    I got my VirtualBox totally screwed up, I removed the O/S (Windows 8 and Server 2008) and tried to start over. I didn't install them properly, now when I try anew it says "this folder already exists and possibly belongs to another machine" now I can't do anything so I thought I would uninstall...

    celshaug15 pointsBadges:
  • What are the technical capabilities for Parrot versus other VMs?

    This is more of a general question: I know Parrot is the virtual machine that was originally designed for Perl 6.I'm actually trying to figure out what the technical capabilities Parrot"s VM offers against other competing VMs (Java Virtual Machine/Common Language Runtime)? Thanks!

    ITKE62,120 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer500 pointsBadges:
  • Link Oracle 10g with SQL Server problem

    I have created a link between our Oracle DB and SQL server db It was successfully created and I was able to select data from oracle table using SQL Server. Then I have created a view in SQL Server using this link to read from Oracle, the view was created: create view dah_test as ( SELECT count(*)...

    Kmadani35 pointsBadges:
  • Running a query on both SQL Server and Oracle databases

    How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:
  • Email reminders through Oracle Forms 10g

    Hi, is there a way to send an email reminder and mark user's calendar through Oracle Forms 10g?  Any help is appreciated.

    hponnal5 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:
  • Create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?

    Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server restore job fails

    I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

    TuftsDBA0 pointsBadges:
  • SC delete OracleServiceXE is not working for me

    I have removed Oracle from system, but when I try to install it again, I'm getting the error as an instance of Oracle already there please remove the files and re install again. I have delete all files, but I'm still getting same error. As suggested above, I have try to run sc delete...

    Reddy0075 pointsBadges:
  • Connecting to SQL Server from an Oracle procedure

    We need to pull data from a SQL Server database, and our database is Oracle. How would I connect to SQL Server from an Oracle procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Steps to install oracle 8 on windows 7

    What are the steps to install Oracle 8 on Windows 7?

    saabil15 pointsBadges:
  • Oracle perfomance tuning

    How to tune Oracle SQL queries. Please tell me step-by-step.

    QgyOgtX5 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