• Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • PL/SQL – How to make a check whether the attribute is positive or zero

    Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

    Inprise610 pointsBadges:
  • Open ended SQL queries

    Hi all, I have a requirement to trace the open ended SQL queries running in Oracle Can anyone please help me with a solution. Also please provide me some links where I can find info about Open ended SQL queries. Thanks in advance

    ssk25010 pointsBadges:
  • JDE with Robot/Schedule

    Hi All, Our new E1 interface to Robot seems to have created an issue where previous EDI react jobs are not finishing in the OS and so Robot Schedule continues to think they are still running. After looking at the job log for the hung job I noticed it only created a data queue in the ROBOTLIB. I...

    northwoods180 pointsBadges:
  • Is D2K is compatible with Oracle 12 or 11

    Is D2K is compatible with Oracle 12? My application has been developed in D2K and with database Oracle 8i. Now I want to change Oracle 8i to Oracle 11 or Oracle 12.

    sunil3175 pointsBadges:
  • Access violation at address 00F03267 in module ‘Toad.exe’.

    This is an issue when connecting to a database; access violation at address 00F03267 in module 'Toad.exe'. what can I do to resolve this error? Thanks in advance.

    Bigsammy2925 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    oracle to ms access

    Vsrameshkumar025 pointsBadges:
  • oracle 10g query

    i need sum of income amount from income table and sum of expense amount from expense table to calculate the profit or loss. i have no idea how can i link these two tables.

    Zaman31502110 pointsBadges:
  • Oracle 10g express edition problem

    Sir I'm using Oracle 10g express edition but when I try to open the homepage (start-->oracle database 10g express edition-->go to database homepage), it displays a message " 127.0.0.1:8080/apex" unable to open. What should I do now?

    bottle2neck5 pointsBadges:
  • how to run proc in Oracle 10g

    I have oracle 10G (GUI based-running in IE) .how do i compile and run proc code in it

    ITKE346,360 pointsBadges:
  • 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...

    ITKE346,360 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'?

    jkeri360 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!

    ITKE346,360 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:

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