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

    ITKE346,360 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?

    ITKE346,360 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?

    ITKE346,360 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.

    ITKE346,360 pointsBadges:
  • How to get the list of all tables in Oracle database

    I apologize for the short question but is there a way that I can get my Oracle database to display the names of all the tables in it? A query perhaps? Thank you.

    ITKE346,360 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE346,360 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

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

    ITKE346,360 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!

    ITKE346,360 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...

    ITKE346,360 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