• Using select statement in an update query of Oracle SQL

    how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows

    Farhandgr85 pointsBadges:
  • I forgotten my user name and password of Oracle 10g express edition.

    I'm using oracle 10g express edition, I forgotten my username and password so please suggest me any idea to recover the username and password or tell me any other possibilities to reset the username and password.

    Sreekannan5 pointsBadges:
  • Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

    Desjacks5 pointsBadges:
  • Converting and deploying 6i Forms to Forms 10g

    I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that's true, then how do I run them? Is there a runtime with 10g? I feel like an idiot,...

    Herbiebill35 pointsBadges:
  • Formatting PL/SQL code in SQL Developer

    Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

    Inprise610 pointsBadges:
  • Problem with ORA-01034 and ORA-271017

    I am running Oracle 11 on Linux Ubuntu 12.10. The database has been running well for a long time. Now, suddenly, when I or one of my applications tries to connect to the database, the database replies with ORA-01034 and ORA-27101.  I've tried most of the available suggestions, and either they...

    tcnmann20 pointsBadges:
  • Setup website in Oracle 8i

    How do I setup a website in Oracle 8i?

    blighali5 pointsBadges:
  • ORA-01009: Missing mandatory parameter


    MAY05659292714145 pointsBadges:
  • Convert single instance database to Oracle RAC on ASM

    Hi, I have single instance database without ASM. Now I want to convert this database to Oracle RAC database using ASM. Please mention the steps to convert this database to RAC. I have version 11gR2 ( Regards Nadir Pervez Gill

    NadirPervez5 pointsBadges:
  • how to open oracle in web browser??

    how to open oracle 10g using web brouser?? nd what is the maximum memory for oracle ?? wht should be it's IP ADDRESS??

    Aamir000860 pointsBadges:
  • How to run Oracle 10g form on Netscape

    How to run Oracle 1og form on Netscape 7.2. It gives me plugin issue.

    musakaleem5 pointsBadges:
  • Output (.LIS FILE) of SQR report

    How to hide the man like symbol at the end of the page of the SQR report? Thanks in advance!

    priyavijayakumar5 pointsBadges:
  • Is It possible to retrieve dropped tables in Oracle?

    Hello Experts, I want to know one thing that is it possible to retrieve the dropped tables by mistake from an application user? If yes then please share the procedure involved it so that I can proceed further accordingly.

    VijayDahiya125 pointsBadges:
  • Delete command is not deleting the form records in details block


    MAY05659292714145 pointsBadges:
  • RDBMS and DBMS in Oracle

    What is RDBMS and DBMS in Oracle?

    Gkg5 pointsBadges:
  • Connect database from Oracle to VB 6.0 in SQL Server

    I'm a BCA student. I'm doing my project on college management system with VB 6.0. I want to know how to connect a database from Oracle to VB 6.0 in a SQL Server. Thanks!

    eliza72472fathima5 pointsBadges:
  • Cache Oracle tables in a NetApp cache

    Sysadmins say our Oracle databases are using virtually none of the 512GB NetApp cache. Is there a way to cache Oracle tables in the NetApp cache similar to the Oracle keep pool?

    royaldbaness5 pointsBadges:
  • UPSERT in Oracle table

    Is there a way to UPSERT in Oracle (so I can insert either / or update a row into a table? I thought Oracle doesn't have that statement so I'm not sure the best way to do it. Thank you.

    ITKE371,790 pointsBadges:
  • Current Example does not handle duplicate Value 1 population

    IF we take the same example and Ray has a 2 rows where Value 1 is populated. Max will return only 1 row.....how do you collapese the rows so that both values retained for Ray and perhaps take it further align the similar values. Asuming that all of these rows belong to 1 FK

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