• 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 =...

    ITKE434,585 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?

    ITKE434,585 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...

    ITKE434,585 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.

    ITKE434,585 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.

    ITKE434,585 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:
  • 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:
  • 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...

    ITKE434,585 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?

    ITKE434,585 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...

    ITKE434,585 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...

    ITKE434,585 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?

    ITKE434,585 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.

    ITKE434,585 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