• SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • Execution of Oracle 11g wrapped procedure gives ora-00900 error

    Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it...

    askmsc15 pointsBadges:
  • Stop Oracle database using by other application

    I have Oracle 9i database & want to stop other people from using it and use other applications like SQL Developer & Toad.

    Waris10 pointsBadges:
  • How to install Oracle 9i on Win 2008 server?

    error :- jrew.exe has stopped working so database not generated

    patilsudam5 pointsBadges:
  • Oracle 9i data dictionary definition & informational SQL queries?

    I am using Oracle 9i on a specific application that was designed back in 2000 -- no supporting documentation, very little training and I'm new to Oracle and sql. I'm currently using Toad for Oracle which allows me to create query templates. Toad for Oracle has existing sql templates which I can...

  • Upgrade to Oracle/Intel: Go Linux vs Windows

    We are planning upgrade our main database cluster (rs6000/aix) to Oracle on Intel, research done give a lot of papers from dell, hp, intel that about roi of moving out of risc/unix but there is no clear evidence about performance issues between LINUX and Windows Server as the selected OS. Do you...

    Romerogt0 pointsBadges:
  • Upgrade Oracle 9i to 10g

    Hi All, Software:- Oracle 9i,Oracle 10g OS - Solaris 9. We have 5 databases in our development environment. All the databases(9i) are running on Solaris 9 OS. I have given responsibility to install oracle 10g on Solaris box(development environment). Once the 10g gets install then upgrade one of the...

    Philip1235 pointsBadges:
  • can i install oracle 9i on windows7 operating system?

    can i install oracle 9i on windows7 operating system?

    Or20 pointsBadges:
  • Oracle report 6i, report has 2 parameters and runs fine independently but i run this report from a form with parameters; reports ignore the parametrs

    Report runs fine separately but when i call from a form and pass on required paramets, it does not show anything;

    Shaikhoo5 pointsBadges:
  • FRM-40403 A CALLING FORM HAS UNAPPLIED CHANGES SAVE NOT ALLOWED

    Dear Friends I have order data entry screen form when the order item is not yet defined then I am using this script for calling the item definition form DECLARE l_n_curr_rec NUMBER; BEGIN BEGIN :global.l_n_curr_rec2 := :COP_ORDER_DETAILS.LINE_NO; :GLOBAL.CLASS_CODE := :CLASS_CODE; :GLOBAL.LINE_NO...

    MAY0565929271495 pointsBadges:
  • oracle 9i in windows 7

    i installed oracle 9i in windows 7 os,and i open sql plus and login as scott and tiger it gives authentication fail message,pls help me,same i installed in win xp it works fine,one of my frnd says oracle 9i doesnot works on win7,he formatted win 7 and installed win XP

    Rsg30 pointsBadges:
  • Oracle 9i error message in Windows 7: jrew.exe

    while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows 7)

    Sayedtawfik5 pointsBadges:
  • Oracle RR Date Format

    TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)

    JOGENDER20095 pointsBadges:
  • ORA106500:WHEN-BUTTON-PRESSED raised unhandled exception. … i want to open ms word file when button pressed trigger

    Dear All i am using oracle 6i and oracle 9i database i want to open word file when pressed button in form but there is no error during compilation error at runtime showing below code wrote in WNBP trigger: declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin('C:ProgramDataMicrosoftwindowsstart...

    9492587845 pointsBadges:
  • VB6.0 Connectivity to Oracle

    How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx ...  Saurabh

    981500799910 pointsBadges:
  • Strange Oracle 9i behaviour

    We are seeing some very strange behaviour in the performance of a query on our database. We have run the same query on the actual database server (s1) using sql+, and on a server (s2) 1 hop away (taking out network performance). The exact same queries, without any bind variables, are kicked off...

    Darryn765 pointsBadges:
  • Oracle 9i eating up storage

    i am using winxp sp3. i had installed oracle 9i server. it was installed succesfully before it takes only 2.8gb space. But now it is occuping all left space in c drive. as 15gb was free in c drive , now it takes 16gb space and when i uninstall any software the space made by uninstalling it also...

    Oo715 pointsBadges:
  • Execution of Oracle 9i Developer Suite compiled form (fmx) ?

    How to execute 9i DS compile form (fmx) from my PC desktop?

    Jamalhamid5 pointsBadges:
  • Replicating Oracle 10g database in Oracle 9i

    I have an oracle 10g database and would like to create a replica of it in oracle 9i. Could you please explaim if this is possible. I'm sure there would be backward compatibility issues to contend with.   Regards,

    Yomex5 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