• 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?

    ITKE352,420 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.

    ITKE352,420 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?

    ITKE352,420 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!

    ITKE352,420 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...

    ITKE352,420 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:
  • IT career planning for SAP

    Dear Sir, This question may have been asked to you million times so I'm sorry for that. Which career path in SAP I should choose to enter into the SAP domain. I have 10 yr of IT experience...6 to 7 years of coding and design in Microsoft technologies like VB, ASP, .NET, etc. I also have good...

    Robu5 pointsBadges:
  • How to insert an image file into an Oracle 8i database

    How do I insert a picture into an Oracle table?

    Oracledatabase15 pointsBadges:
  • To view the Oracle database table in all of the data record, will be stuck

    Query tables in the Oracle database with PL/SQL tools, can be successful, but when unwrapped all the rows of the table, will card to death. Different table, a table on the number of rows is different, but generally only 200 or so rows, then the SQL window card died (other SQL window can continue to...

    hjcj19891295 pointsBadges:
  • How to recover from ORA 01033 Oracle installation or shutdown in progress error

    After UPS failure my database failed and given ORA-01033 error. I stopped all Oracle services and copied ORA data file to another server, having same database name and SID. The old Oracle was in C Drive and new is in E Drive. I am getting the same error. Can I recover my data anyway. Please help....

    Gianmoor10 pointsBadges:
  • Inserting parent and child tables at a time

    Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.

    Ammu35 pointsBadges:
  • Tutorial questions and answers

    Queries on Oracle database black screen?

    comp210 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