Oracle

Tunning and Performance in Oracle 8i

we have a 20 users accessing application of vb and database is oracle 8i from morning server runs fine till after noon it slow down then we need ot restart the database then again for an hour it works fast but again it gets slow donw can you please suggest what to do ??? Software/Hardware used:...

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 Software/Hardware used: Oracle 10g

SQL Developer: missing expression on insert into with select rownum

insert into TEMPLE_BDMS.TEMP_QSP values ( select rownum as uniqrownum, doc_id, doc_type, barcode2, barcode3, barcode4, routing_status, scan_date, assignee, scanner, scan_station, pfile_name, new_doc_id, new_doc_type, new_doc_type2 from TEMPLE_BDMS.QSP_SOURCE where pfile_name not like '%_0001.%' ) ...

OneWorld - Xe - Enterprise One

Other than name change each time product was sold (JDE>PeopleSoft>Oracle) and of course updates/enhancements is there any real difference between OneWorld, Xe and Enterprise One?  Hence does a OneWorld certification count in Enterprise One?

Edit Distribution Set - Oracle 11i User

I would like to know how to insert a new data record into the middle an existing Oracle Distribution Set, rather than add new data at the end of the set. Software/Hardware used: Oracle 11i

Oracle APEX: calendar size

Hello, there's been a change to my calendar on apex where it's now half the size it used to be (before, it used to fill up the entire screen). I'm not sure what I changed... can someone help?!

how to set the tab canvas first tab at runtime in oracle forms?

how to set the tab canvas first tab at runtime in oracle forms? Software/Hardware used: Oracle Forms

who will buy TIBCO in the end.

Thinking on which vendor is most likelty to benefit form such a deal I conclude it is Microsoft. Because ibm and oracle+sun are selling hardware by licencing unix servers and microsoft had to play catch up.

call outlook from JDE

I would like to call outlook form JDE Address Book when I click on a customers email address.  Can this be done and if so can you explain how?

Basic Oracle question

This might sound a little wierd, but I am a non-techie. So Apologies first for posting such basic questions here. I would like to know how are certain Oracle Applications or technology solutions developed? In the sense, what is the language used to develop E Business Suite. Or what was the...

how do I install Oracle Reports 6i Runtime on IBM HttpServer?

how do I install Oracle Reports 6i Runtime on IBM HttpServer? Software/Hardware used: WebSphere 6.1 Application Server and IBM HttpServer

Oracle Reports problem

I am migrating an old classic asp with vb5 mts application from Windows NT to a Windows 2003 server (with no documentation). The application is used to send faxes via Goldfax, and it creates the faxes using Oracle Reports 6i, which is where I am having the problem. In order for Goldfax to be used...

Oracle 10G Issues

The problem I'm having is that MDAC 2.5 is no supported by 10G...I installed MDAC 2.8...When I went into the ODBC DSN drivers (Admin ODBC console) MS for Oracle was still there...the new driver for 2.8 was not visable. We used Oracle 10G client to connect...but it could not return a "ADO Recordset"...

Connect to Oracle 10g with VB 6

Hving a problem with an existing VB 6 app connecting to 10g pulling back a recordset...it is clustered so that is an extra level of complexity...it was written using MDAC 2.5

oracle bulk inset utility

I am bulk inserting records from an array to a table i used save exception to record the exception during the bulk insertion. but this utility only gives the error code.then later i fethed error message from the eror code but this message is generic not specific.(not the exact exception message) .i...

Issue with designing Oracle Application Express (APEX)

Hi, I am facing a problem in my local application express box. While I am trying to create a button in the item section in a page ( using create multiple items by drag and drop ), it is happening without any error but not creating the button . This is working fine in online practise site(...

Tuning SQL query with hierarchy result through DB link

I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ...

oracle 10g query

attributes of income table are(id,date,income_amount) and of expense table are(expid, expdate,exp_amount,paid,unpaid).i need sum of "income_amount" and sum of "paid" to calculate the profit or loss.

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.

Oracle Reports server

Reports server fails with REP-52266