• Oracle: Putting more than 1,000 values using the IN clause

    Would there be a way to put more than 1,000 values in Oracle 10g using a static IN clause? I currently have a comma delimited list of IDs that I would like to use in the IN clause. When I hit 1,000 items, Oracle is giving me an error. Here's the query I'm using: select * from table1 where ID in...

    ITKE350,830 pointsBadges:
  • Error:1327 during installing orcale 10g

    I downloaded 10g express edition and tried to install to windows xp. An error 1327:Invalid Driver:E\ prompted. There is no E drive at all. Not sure what is going on? Anyone could help?

    Canaantt5 pointsBadges:
  • Developing standalone Apps with Oracle Developer 10g

    Hi, I'm new to oracle 10g development. can i build an application using oracle forms developer 10g and run it without deploying in the application server.(i.e without using Oracle 10g Application Server) thanks np

    Nareshpriya5 pointsBadges:
  • How can I download Oracle Version 10.2.0.3

    Dear all! Could you help me to download Oracle Version 10.2.0.3, All the best, Regards, Trong

    Wwwtrong1235 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:
  • How to work with JavaBeans in Oracle Forms 10g

    I've downloaded "First Bean" Demo but i dont understand how to use/implement it. I dont know much about Java Programming.In Forms 10g, when i draw a bean and give "oracle.forms.demo.canvasproperty" in Implemantation Class property of bean, an error occurs FRM-13008: Cannot find java bean with name...

    511206925 pointsBadges:
  • Oracle 8i to Oracle 10g Export /Import

    Hi, Presently I'm Exporting the Oracle Database of 8i version 8.1.6.0 on HP-UX to import on Oracle 10g 10.2.0.3 So my question is there is any need to apply 8i Patch before taking export i.e; from 8.1.6.0 to 8.1.7.4 this is the last & latest patch of 8i to support 10g so I want to ask you that...

    134915 pointsBadges:
  • unable to install Oracle 8i in Windows 7

    please help me to install oracle8i in windows7.it is giving error not found jrew.exe

    Hem5 pointsBadges:
  • How can I synchronize database data from Windows Server to Ubuntu

    I have Oracle 10g installed on Windows 2003 Server. I want to import/sync data from Windows Server to Ubuntu 14.04. Please help me. Thanks, Netra

    netrak5 pointsBadges:
  • Why can’t I export and import in Oracle 10g database?

    Export and Import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and login using a different role before trying again.

  • Store information from other computers through LAN in Oracle 10g

    How can I store information from other computers connected by LAN in Oracle 10g? For example: The datetime of a computer.

    PREETYSUMAN5 pointsBadges:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri360 pointsBadges:
  • Two Oracle 10g listeners running at the same time

    Hi all, can you help regarding oracle 10g listener? Sometimes for no reason i cannot log on int database, and then found there is two listeners running at the same time, do you know why?

    261715 pointsBadges:
  • Looking for my Oracle 10g username and password

    I need my Oracle 10g user name & password. Just now, I installed Oracle 10g software. Can anybody help me in this case?

    mani59775 pointsBadges:
  • How to generate alerts via forms in Oracle 10g?

    Hi all,    SELECT Count(1)    FROM regal.regal_inv_landed_cost_tab a    WHERE organization_id = 81    and not exists(SELECT a2.inventory_item_id  FROM mtl_system_items_kfv a2                                         where a1.inventory_item_id =a2.inventory_item_id    ...

    sivasurya20 pointsBadges:
  • Hide ID and Password in web.show_document

    How do I hide the id and password in a web.show_document command executed from an Oracle 10g form?

    Janiroo210 pointsBadges:
  • convert report to excel without convater

    Is it possible to convert a 10g generated report to excel without excel convater?  

    MCAMCom15 pointsBadges:
  • oracle 10g query

    i need sum of income amount from income table and sum of expense amount from expense table to calculate the profit or loss. i have no idea how can i link these two tables.

    Zaman31502110 pointsBadges:
  • Oracle 10g express edition problem

    Sir I'm using Oracle 10g express edition but when I try to open the homepage (start-->oracle database 10g express edition-->go to database homepage), it displays a message " 127.0.0.1:8080/apex" unable to open. What should I do now?

    bottle2neck5 pointsBadges:
  • how to run proc in Oracle 10g

    I have oracle 10G (GUI based-running in IE) .how do i compile and run proc code in it

    ITKE350,830 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