• How to insert BLOB in an Oracle database using C#

    We have to persist a .CSV in our Oracle database but we're trying to not to use procedures (so we have a more testable application). Basically, we want to generate a file and put it in the database. Anyone know how to do this with code (particularly BLOB with C#)?

    ITKE409,335 pointsBadges:
  • Error message through Email notification in Oracle Forms

    How do i send error message through Email notification in Oracle Forms?

    Swethareddy8815 pointsBadges:
  • Creating a copy of an Oracle table without the data

    Would it be possible to create a copy of an Oracle table without actually copying the data? I believe I already know the statement: create table xyz_new as select * from xyz; But I think this copies both the structure and the data. I'm just trying to get the structure. Thanks!

    ITKE409,335 pointsBadges:
  • How to turn off password expiration permanently in Oracle 11g

    I've been using Oracle for my development testing. But now the password for my bootstrap account that I always use to rebuild my database has expired. Is there a way to turn off the password expiration for users permanently? I'm currently using Oracle 11g. Thanks so much.

    ITKE409,335 pointsBadges:
  • 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 =...

    ITKE409,335 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?

    ITKE409,335 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...

    ITKE409,335 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.

    ITKE409,335 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.

    ITKE409,335 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...

    ITKE409,335 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?

    ITKE409,335 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?

    ITKE409,335 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...

    ITKE409,335 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