• Update statement with inner JOIN query isn’t working in Oracle

    We have a query that works fine with MySQL. For the past few days, we've been trying to get it to work in Oracle but keep getting the following error: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" Here's the query we're using: UPDATE table1...

    ITKE352,420 pointsBadges:
  • Can I clone a user in the same Oracle database?

    I have the need for a SQL query that will clone an Oracle user. For the source, I already have a user that has the necessary privileges. Would there be a way to clone the user but with a different username in the same database?

    ITKE352,420 pointsBadges:
  • Benefits of Oracle database 10g vs. 11g editions?

    What are the benefits of Oracle 11 g edition over Oracle 10 g express edition?

    MUKUNDSAWANT55 pointsBadges:
  • Getting ORA-01882 error when accessing Oracle database through a Java application

    I've been trying to access an Oracle database through a Java application but when I try to run the app, I keep getting this error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Anyone have an idea on what I should do here?

    ITKE352,420 pointsBadges:
  • How can I install Oracle 11g client?

    I've been trying to install Oracle 11g (client) but I keep getting this error: Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. Expected Value: 1023 Actual Value : 1028 List of errors: - PRVF-3929 : Adding...

    ITKE352,420 pointsBadges:
  • Receiving ORA-01033 error message on Oracle 11g

    I recently installed Oracle 11g on Windows 7 and everything has been working great. But now I keep getting this error message: ORA-01033: ORACLE initialization or shutdown in progress. I've tried to figure it out but I'm still getting the error. I tried connecting as "SQLplus sys/sys as sysdba" but...

    ITKE352,420 pointsBadges:
  • Can I use an Oracle 11g client on a Oracle 10g server?

    For the past few months, I've recently created a .NET program that uses ODP.NET, specifically with Oracle 11g. But our Oracle server has been running 10g and I can't make a change. Can I run an Oracle 11g client on a 10g server? Or am I in big trouble?

    ITKE352,420 pointsBadges:
  • Connection of Oracle 8i i VB 6.0

    How to establish connection of Oracle 8i i VB 6.0

    Wasim5 pointsBadges:
  • What’s the difference between Oracle 9i, 10g, 11g?

    And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only.

    Pooni20 pointsBadges:
  • How can I create a temporary table in a Oracle database?

    I've been trying to create a temporary table in my Oracle database but I'm not sure how to do it. I have this so far: Declare table @table (int id) And I need to populate with a SELECT statement too. Appreciate the help.

    ITKE352,420 pointsBadges:
  • Oracle: Killing a running SELECT statement

    We're using Oracle and we're trying to figure out how we can stop a running SELECT statement by killing the session. It's continuously giving us output based on the statement but we need to stop it in between.

    ITKE352,420 pointsBadges:
  • What’s the fastest way to bulk Insert from .NET to Oracle?

    I have to transfer about 160,000 records from .NET to Oracle. What would be the fastest way to bulk INSERT? I've been using INSERT statement but it's taking about 30 minutes to complete. The source data is currently in a DataTable (it's from another MySQL database). Thanks!

    ITKE352,420 pointsBadges:
  • Loading an XML file into Oracle

    I have a large XML file and I need to load it into Oracle. How can I directly load it into Oracle? I'm looking for a server-side solution. Can anyone help me?

    ITKE352,420 pointsBadges:
  • Can I achieve auto-increment in Oracle without using triggers?

    Is there a way to achieve auto-increment in Oracle rather than using triggers? I'm working on a project and triggers won't work for me.

    ITKE352,420 pointsBadges:
  • Oracle: Putting more than 1,000 values using the IN clause

    Would there be a way to put more than 1,000 values in Oracle 10g using a static IN clause? I currently have a comma delimited list of IDs that I would like to use in the IN clause. When I hit 1,000 items, Oracle is giving me an error. Here's the query I'm using: select * from table1 where ID in...

    ITKE352,420 pointsBadges:
  • Error:1327 during installing orcale 10g

    I downloaded 10g express edition and tried to install to windows xp. An error 1327:Invalid Driver:E\ prompted. There is no E drive at all. Not sure what is going on? Anyone could help?

    Canaantt5 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE352,420 pointsBadges:
  • Where can I download Demo Oracle JD Edwards EnterpriseOne 9.0?

    Can I have any links for that? Please Let me know? How Can I Download Demo Version of Oracle JD Edwards Enterprise One 9.0? Can I have any links for that? Please Let me know? I am a new to ERP I want to practice in home. Is it possible to work without Internet after installation? Regards

    Abdul2rahim5 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 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