• Performing a multi-row insert into Oracle 9

    I've been trying to find the easiest way to perform multi-row inserts into our Oracle database (it's Oracle 9). This code has been working for me in MySQL but it's not working in Oracle: INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, EXCH_NAT_KEY, EXCH_DATE, EXCH_RATE, FROM_CURCY_CD, TO_CURCY_CD,...

    ITKE357,210 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE357,210 pointsBadges:
  • 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#)?

    ITKE357,210 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.

    ITKE357,210 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?

    ITKE357,210 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?

    ITKE357,210 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.

    ITKE357,210 pointsBadges:
  • File Authentication

    Hi everyone, I'm new to this forum,, currently i am not working anywhere, I'm a fresher. I have to give my Database Administration Fundamentals1 exam. Can anybody tell me the details about :- "SET UP FILE AUTHENTICATION" Please reply ASAP. That will be grateful to you. thanks in advance

    989986944515 pointsBadges:
  • How do I insert, update and delete works (internally) in Oracle database?

    Can you explain the states of DB buffer cache, redo log buffer, undo table space etc, when DML statements are executing?

    Pulak555 pointsBadges:
  • How to I write a SQL query to ignore case in a Oracle database?

    In my Oracle database, I have a SQL query that I want to ignore case. See below: SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe' So if I want the query to return either "IGNORECASE", "ignorecase" or a combination of them, how can I do that? Would that be possible?

    ITKE357,210 pointsBadges:
  • Character limit for a column in an Oracle database

    I'm looking to store different postal codes in my Oracle database. I believe the column will be a VARCHAR2. I know the U.S. codes are 9 and Canadian codes are 7. Would 32 characters be efficient enough for the limit in the column? Or should I go higher? Thanks!

    ITKE357,210 pointsBadges:
  • Why should we use an Oracle database over others?

    We're looking to decide which database system we should use for our organization. We're leaning towards using an Oracle database but we're looking to first know why we should choose that over other databases (SQL Server, MySQL, PostgreSQL). Basically, we would like to know what features make it...

    ITKE357,210 pointsBadges:
  • How to recover my Oracle database in DBF?

    Hi everybody, I'm getting the following error on starting Oracle database through the enterprise manager console: ORA-01122: Database file 2 failed verification check ORA-01110: Datafile 2 'D:\oracle\oradata\new1\undotbs01.dbf' ORA-01200: Actual file size of 72733 is smaller than correct size of...

    OugustChshrien5 pointsBadges:
  • GIS for Oracle

    In my relational database, I have the following table: Tableau: Clim data Region_id      ---  temperature SD                  ---  20 SD                  ---  25 SD                  ---  30 SD                  ---  33...

    abdmet7425 pointsBadges:
  • Code to Update retrieved record in Oracle Forms 6i

    In Oracle Forms 6i, can anybody tell me about code to update data retrieved from database, which can be place under When Button Pressed trigger?

    Jehangir5 pointsBadges:
  • How to display non existent data as 0 in Oracle

    in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so...

    Deb4u50 pointsBadges:
  • Access Oracle Database via Internet

    I want to access Oracle Database via internet. Please tell me about it and the steps required. How can we deploy Oracle Forms 6i on Web.

    Amjadbinali35 pointsBadges:
  • Converting Oracle Report to Excel

    How do I convert my Oracle D2K report to Excel?

    Sourabh99910 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