• Fuzzy search in Oracle SQL

    Hi, We need to fuzzy search on table which have 20 million records and its will be growing continuosly adding 20K records each day. Our application is J2EE environment where we make a jndi call to database and run the queries. Fuzzy search query what we have is the below query which search for...

    surajul5 pointsBadges:
  • Upgrading Forms30 on Oracle 7.0

    I am upgrading Forms30 on Oracle 7.0 to Oracle 10g First, I am upgrading to Oracle forms 6i using Forms compiler and facing these problems: Converting language on display item. (it doesn't show the right language on display item and headers) Key mapping function. I need script so I can convert all...

    Oikhleif30 pointsBadges:
  • System doesn’t support code in OracleClient

    I am new to VB.Net. I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why?

    Dax70 pointsBadges:
  • Unhandled exception of type ‘Oracle.DataAccess.Client.OracleException’ occurred in oracle.dataaccess.dll

    An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _...

    Dax70 pointsBadges:
  • How can I get the last row of a table in an Oracle database?

    I have an Oracle 11g Express database and I'm having trouble getting the last row in one of my tables. Can anybody help me with this? Thanks so much.

    ITKE351,865 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.

    ITKE351,865 pointsBadges:
  • Disable all table constraints in Oracle

    Would I be able to disable all the table constraints in Oracle using one single command? It doesn't matter what table it is. It can be for a a single table, list of tables or for all tables. Thanks so much!

    ITKE351,865 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • My Oracle server is corrupt, and can’t start using Oracle 8i

    Hi, We have a database that is running Oracle 8i on Windows 2000 server, but unfortunately it seems corrupt. our intention maybe would be to re-install the database on another machine and migrate all the applications. Please give us a guided approach to this problem, the database name DBCAB. Is it...

    Schinama15 pointsBadges:
  • Spyware will damage my system

    I have a spyware on my oracle server. I tried many antispy softwares to clean it but no use, lastly the PC restarts automaticly after windows login. Is there any spy cleaner can remove it befor windows login or clean PC through booting?

    Rosealzubi115 pointsBadges:
  • 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...

    ITKE351,865 pointsBadges:
  • Database Migration code in MySQL

    Code to migrate database in MySQL (tables, triggers, stored procedures, functions and views) to Oracle, MS Access & vice versa.

    akashi5 pointsBadges:
  • ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name \

    I am getting this error in my system: ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name. How can I resolve this issue?

    chethanhb5 pointsBadges:
  • Oracle 11g R2 Forms and Reports error in configuration progress

    Dear all, While installing fusion middleware 11gR2 in Windows XP (32 bit) the process is hanging after completing step 14 of 15 (Configuration Progress) for more than 2 hours. Step creating domain failed. Configuration action 'Creating Domain' has failed. Kindly perusal my attachment file and give...

    Himac225238435 pointsBadges:
  • Oracle 10g terminated_with_error

    While I'm running an Oracle 10g report using the following code: declare   repid REPORT_OBJECT;   v_rep VARCHAR2(100);   rep_status VARCHAR2(50);  BEGIN   repid := FIND_REPORT_OBJECT('REPORT1');   SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms');...

    K197070 pointsBadges:
  • Error when using Microsoft OLE DB for Oracle in DTS Package

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 pointsBadges:
  • How to set oracle database path with oracle developer

    how to set oracle database path with oracle developer

    Orcl5 pointsBadges:
  • Report language change in Oracle Reports 6i

    I have a report in which report headings query is main query and report data query is sub query. I want to change the report language based on the language data available in the child query. Can anyone suggest to how to proceed?

    diliptiwari5 pointsBadges:
  • Win Drupal’s Building Blocks!

    Are you a developer? Today's free IT book is an essential addition to your library: Drupal's Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels after you win this great resource. There are two ways to win this book: Answer one of five questions and post the link to...

    MelanieYarbrough6,345 pointsBadges:
  • Trying to install Oracle 10g

    I'm trying to install Oracle 1OG on an Acer 5520-5334 computer and it has been giving me a particular error 'No valid devices found, etc.) From my research, it seemed like the versions of Red Hat OS (RHEL 3.0,4.0) were not compatible with my computer. Please can anyone give me advice on what Red...

    DANIA5 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