• Oracle: Killing a running SELECT statement

    We're using Oracle and we're trying to figure out how we can stop a running SELECT statement by killing the session. It's continuously giving us output based on the statement but we need to stop it in between.

    ITKE351,965 pointsBadges:
  • What’s the fastest way to bulk Insert from .NET to Oracle?

    I have to transfer about 160,000 records from .NET to Oracle. What would be the fastest way to bulk INSERT? I've been using INSERT statement but it's taking about 30 minutes to complete. The source data is currently in a DataTable (it's from another MySQL database). Thanks!

    ITKE351,965 pointsBadges:
  • Loading an XML file into Oracle

    I have a large XML file and I need to load it into Oracle. How can I directly load it into Oracle? I'm looking for a server-side solution. Can anyone help me?

    ITKE351,965 pointsBadges:
  • Can I achieve auto-increment in Oracle without using triggers?

    Is there a way to achieve auto-increment in Oracle rather than using triggers? I'm working on a project and triggers won't work for me.

    ITKE351,965 pointsBadges:
  • 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...

    ITKE351,965 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

    ITKE351,965 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 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:
  • 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 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:

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