• Setting Oracle database to auto-commit

    Is there a way for me to find out if my Oracle database is set to auto-commit? If it is, how can I turn that off too? Thanks!

    ITKE413,420 pointsBadges:
  • Cannot connect to Oracle database: Oranos.dll is missing from my computer

    I've been trying to connect to my Oracle database but when this code is running (con = new OracleConnection(oradb);), it keeps giving me this error message: The program can't start because oraons.dll is missing from your computer. Try reinstalling the program to fix this problem. What should I do?...

    ITKE413,420 pointsBadges:
  • Deleting millions of records in Oracle database

    My Oracle database has roughly 2 billion (yes, I said billion) records. But we noticed that over 10 million of them are duplicates. How can we go about deleting those? Thanks!

    ITKE413,420 pointsBadges:
  • Free Oracle Assessment Exams

    Can someone tell me where I can find free Oracle Assessment exams in preparation for Oracle certifications?

    Stewary5 pointsBadges:
  • Getting all sequences in Oracle database

    Hi experts! Would there be an Oracle command I could run so I could get all of the sequences in my Oracle database? This is for Oracle 11g / Oracle Toad. Should I use the command line?

    ITKE413,420 pointsBadges:
  • Manual uninstall of Oracle

    For some reason (this only happens once in a while) but my Oracle database on Windows disappears. Because of this - I'm thinking of doing a manual uninstall. How can I do that?

    ITKE413,420 pointsBadges:
  • Insert table into existing Oracle column

    I noticed that whenever I try to add an existing to an existing column in Oracle, it's always down at the end of the table. Is there an Oracle command where I can tell it to put it in the table? Thank you.

    ITKE413,420 pointsBadges:
  • Compare SQL Server and Oracle databases

    Our department currently has an SQL Server database and Oracle database. One of the tables is labeled 'Inventory' - which has thousands of rows from both databases and it will continue to grow over time. Now, here's what we need to do: We have to compare the Oracle data to the SQL Server data so we...

    ITKE413,420 pointsBadges:
  • Create foreign key in Oracle using ON UPDATE CASCADE

    I'm working with both Oracle and SQL Server. And in SQL, I created a foreign key with the ON UPDATE CASCADE option. So basically, whenever I update the column in the primary key - all of the other foreign keys (in tables) will be updated too. But I'm not sure how to do this in Oracle. Can someone...

    ITKE413,420 pointsBadges:
  • Check whether Oracle instance has started

    Would there be a view in Oracle so I can see whether an instance has been started with a PFILE or SPFILE file? Thanks so much.

    ITKE413,420 pointsBadges:
  • I would like to take a backup of Oracle Database by using unix scripts

    I would like to take a backup of Oracle Database by using Unix scripts. Is it possible? If yes, please provide the details.

    shamcpt5 pointsBadges:
  • Oracle vs Java programming

    Which is better Oracle or Java? I have a interest in programming. What should I learn?

    Linux - Ask the Expert270 pointsBadges:
  • Data migration from SQL Server to Oracle

    For my job, I have to move over data (particularly table data) from SQL Server to Oracle. This usually happens on a weekly basis. What's the best way to do it automatically / repeatedly? Thank you.

    ITKE413,420 pointsBadges:
  • Oracle Certification?

    Hi, I want to know, the total procedure for Oracle data base certification. Thanks

    Amin4rmOvexTechnology250 pointsBadges:
  • Connect remote Oracle database through PL/SQL Developer

    We have an Oracle database which connects to a remote IP address. Is there a way we connect to it through PL/SQL Developer? Thank you very much.

    ITKE413,420 pointsBadges:
  • Convert hexadecimals to decimals in Oracle SQL

    For Oracle SQL, can I convert hexadecimals to decimals (and possibly back again if need be)? I appreciate the help available.

    ITKE413,420 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 pointsBadges:
  • Oracle SQL developer: Set column to auto increment

    Would there be a way for me to set my column to increment automatically using Oracle SQL Developer? Or is this just not possible? I've done with MySQL before but not this way.

    ITKE413,420 pointsBadges:
  • Database connectivity from Oracle Forms

    We are having a legacy running running on Oracle Forms and Reports. I want to change the database connection to point to a different database, how do I do that? P.S: I am pretty new to forms and reports

    Ms123115 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

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

Thanks! We'll email you when relevant content is added and updated.

Following