• MERGE using DECODE logic to control UPDATE

    MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...

    ITKE62,320 pointsBadges:
  • get a anr record from databse by using max (one Field) and orderby (one filed) desc

    Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

  • Oracle: Can a character set be changed after a schema has been created?

    My boss was so pleased with the response from this site that he asked me to ask another question!  He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to...

    DeloeranGuy55 pointsBadges:
  • Bulk update for every 10k rown among 2L

    Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this

    Praveenkc5 pointsBadges:
  • Using Multiple Oracle Homes patchset application

    Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2, patch...

    Ecv3045 pointsBadges:
  • Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export

    My boss is getting an "EXP-00091: Exporting questionable statistics." error - actually, several identical messages per table - when using the EXP utility to dump several tables in an Oracle database.  I'm not familiar with this utility, so I'm researching the problem for my boss.  The...

    DeloeranGuy55 pointsBadges:
  • Deploying Oracle Database

    I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I'm waiting for your help. Thanks a lot

    Girma30 pointsBadges:
  • Does Oracle 6i have a metadata repository tool set

    Does Oracle 6i have a metadata repository tool set

    Maharrison4525 pointsBadges:
  • The most-watched IT questions this week: Oct. 20, 2009

    Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

    Michael Morisy8,038 pointsBadges:
  • How do you load a CSV file into Oracle?

    HOW TO LOAD .CSV FILE INTO ORACLE

    Dolly275 pointsBadges:
  • Create an Oracle database in a specified location

    how to create database at speciied location in oracle 10g

    Softie5 pointsBadges:
  • calling trigger in oracle db 10g

    hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

    Girma30 pointsBadges:
  • Most popular blog posts this week

    10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

    ITKE62,320 pointsBadges:
  • The most-watched IT questions this week: Oct. 13, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

    Michael Morisy8,038 pointsBadges:
  • Microsoft Server 2003 to Oracle migration

    Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.

    ITKE62,320 pointsBadges:
  • Print Context ID Report in version 3.5.1

    Can someone please tell me how to print a context ID report in UPK version 3.5.1?  I used to be able to get one in a previous version but despite much searching cannot find one in the newer version I have now. 

    Upk5 pointsBadges:
  • Using Property Class

    How Can We Set The Property of An Property Class Runtime in D2k ?

    Praveengalaxy10 pointsBadges:
  • Content Canvas

    How Can I Arrange Or Design The 60 Items With Displaying 10 items at a time.and others are accessible through scrollbar.Rememeber That We Don't Have To Use Stacked Canvas ?

    Praveengalaxy10 pointsBadges:
  • Apache Maven support for Oracle JDeveloper?

    What options are available for Apache Maven integration with Oracle JDeveloper? Moderator Note: This is a submitted question.

    BrentSheets6,875 pointsBadges:
  • Data issue in a Oracle Table

    I have a 180 GB size table. When I select the table,it returns some columns with null data. But if I Select that particular record showing NULL column with a Primary key filter,it is showing data for that column. Please let me know what might be the problem with that table.

    Ctnaveenkumar25 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