• What is RDBMS and ORDBMS?

    What is RDBMS and ORDBMS? I'm preparing for my presentation on Oracle 10g. Can you please help me out?

    momiarain10 pointsBadges:
  • Receiving ORA-00918 error when running SQL query

    In Oracle, I keep getting this ORA-00918 error: Column ambiguously defined when I'm running this SQL query: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id =...

    ITKE350,420 pointsBadges:
  • Running Oracle Application 6i on Windows 8.1

    I have copy Oracle Developer 6i Folder from Windows XP to Windows 8.1 on laptop computer, and also, I have export Oracle from Window XP and imported on Windows 8.1 , so my application is working fine ,but the report is not working ,the Reports Background Engine continue show the message working...

    MAY0565929271495 pointsBadges:
  • Oracle: How to handle a single quote

    Would I be able to insert a record in a column that has VARCHAR data type with a single quote in it? Or should I use two single-quotes?

    ITKE350,420 pointsBadges:
  • Is it possible to call a stored procedure within another in Oracle?

    In Oracle, would I be able to call a stored procedure from within another procedure? Here's what I have so far: SET SERVEROUTPUT ON; DROP PROCEDURE test_sp_1; DROP PROCEDURE test_sp; CREATE PROCEDURE test_sp AS BEGIN DBMS_OUTPUT.PUT_LINE('Test works'); END; / CREATE PROCEDURE test_sp_1 AS BEGIN...

    ITKE350,420 pointsBadges:
  • DBMS_CRYPTO package to encrypt & decrypt in Oracle 11g

    ORA-06521: PL/SQL: Error mapping function > >ORA-06512: at "SYSTEM.DBMS_CRYPTO_FFI", line 3 > >ORA-06512: at "SYSTEM.DBMS_CRYPTO", line 13 > >ORA-06512: at "SYSTEM.ENC_DEC", line 21

    Mohanasundharam5 pointsBadges:
  • How to calculate difference between two timestamps in Oracle?

    Would I be able to calculate the time difference in milliseconds between two different timestamps in Oracle? Thanks so much.

    ITKE350,420 pointsBadges:
  • Which TNSNAMES.ORA file am I using in Oracle?

    Every once in a while, I get this Oracle connection problem because I can't figure out which TNSNAMES.ORA file my database client is using. How can I figure this out? Appreciate the help.

    ITKE350,420 pointsBadges:
  • How to run Oracle Forms 10g on web

    I want to deploy my Oracle Forms 10g on web. What do I do?  Please tell me about it. I'm using Oracle 10g on machine 1. and using developer suit 10g on same machine (1). Now I want to deploye this form on web. I know this possible but how to do this i don't know plz tell me that, where I have to...

    Amjadbinali35 pointsBadges:
  • Extract data from dmp-file without Oracle

    I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me...?

    ITKE350,420 pointsBadges:
  • Database for OLTP

    Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

    Akansha150 pointsBadges:
  • Socket error in Oracle Analytic Workspace Manager

    How can solve no more data to read from socket error in Analytic Workspace Manager? Please help me.

    fatima8310 pointsBadges:
  • How can I determine if a table exists in Oracle?

    I've been writing some different migration scripts for an Oracle database and I'm hoping Oracle has something similar to MySQL's "IF EXISTS" construct. Whenever I need to drop a table in MySQL, here's what I use: DROP TABLE IF EXISTS `table_name`; So if the table doesn't exist, the DROP doesn't...

    ITKE350,420 pointsBadges:
  • Oracle SQL Query

    I have created two tables. One is Item_Master table with the fields Itemno having Primary key and must begin with letter ‘I’, Item_Name(HDD, MONITOR, CDROM, KEYBOARD, UPS), Stock defined as Not Null and Price which is greater than 10000 and less than 30000.Another table is Item_Trans with the...

    RaviMangalore5 pointsBadges:
  • 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...

    ITKE350,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?

    ITKE350,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?

    ITKE350,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...

    ITKE350,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...

    ITKE350,420 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