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

    ITKE440,590 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:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE440,590 pointsBadges:
  • Where can I download Demo Oracle JD Edwards EnterpriseOne 9.0?

    Can I have any links for that? Please Let me know? How Can I Download Demo Version of Oracle JD Edwards Enterprise One 9.0? Can I have any links for that? Please Let me know? I am a new to ERP I want to practice in home. Is it possible to work without Internet after installation? Regards

    Abdul2rahim5 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 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:
  • FILE_NOT_FOUNT while copying lxinst.exe on Oracle 8.0.5

    I am trying to install Oracle 8.0.5 on my virtual machine, Microsoft Windows XP professional version 2002 server pack 2. Following error encounter during installation rsf80.ins(142): FILE_NOT_FOUNT while copying LXINST.EXE Please give any idea to resolve this issue. Thanks.

    arshadch1235 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Import from Excel to Oracle 9i

    How can I import data from Excel to Oracle 9i?

    Binty25 pointsBadges:
  • Customize Apache error page

    In many cases when the apache or the instance is down, end users receive a "Page Can not be displayed" browser. How can I customize that that page to put situation friendly messages so that end user do not have to send mails and ask questions on that. I am trying to look into...

    EBS11isysadmin5 pointsBadges:
  • How can automatically execute a oracle process

    Give me the steps to create a batch file or some executable to run a oracle process (form/report) at any given time. Eg. Every day at 10 PM

    Wimal10 pointsBadges:
  • How can I download Oracle Version

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

    Wwwtrong1235 pointsBadges:
  • About Oracle Forms & Reports

    I am beginner of forms and reports. I need basic coding site for forms and reports. Please, can anyone help me?

    Rajkumarsva25 pointsBadges:
  • Configure Oracle 9i Application Server

    How I configure Oracle 9i Application Server to run a form without starting OC4J?

    Akbarmscjnu20 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:
  • File Authentication

    Hi everyone, I'm new to this forum,, currently i am not working anywhere, I'm a fresher. I have to give my Database Administration Fundamentals1 exam. Can anybody tell me the details about :- "SET UP FILE AUTHENTICATION" Please reply ASAP. That will be grateful to you. thanks in advance

    989986944515 pointsBadges:
  • How to transfer Oracle table data to .CSV file by using PL/SQL coding

    How do I transfer Oracle table data to .CSV file by using PL/SQL coding?

    Tarick215 pointsBadges:
  • Change user password for Oracle Internet Directory

    I have to change the user password cn=orcladmin for internet Oracle directory. How?

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

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

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

Thanks! We'll email you when relevant content is added and updated.