Oracle / EADH
Can someone please explain to me what EADH (Enterprise Agent Data Hub) works?
Answer Question
| Nov 26 2007 11:30 PM GMT
| asked by
Tim B
Oracle Business Applications, Oracle developers, EADH
iSupplier
Anyone know anything about iSupplier and its relationship to ASCP?
Answer Question
| Oct 9 2007 11:50 PM GMT
| asked by
BarbJH
Oracle Business Applications, isupplier
Count Distinct Rows on Multiple Columns
I want to write a single query that counts each distinct Student ID from the following sample data.Sample Data:ID NAME PLAN DESCR--- ------- ---- -------------------101 Michael 010C Cafe- 10.00 Dollars102 Adam 010C Cafe- 10.00 Dollars102 Adam 05CC Cafe- 5.00 Dollars103 Jane 010C Cafe-...
View Answer
| Jan 5 2007 8:23 PM GMT
| asked by
mjackson
Database, Oracle, DB2
Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B.The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server...
View Answer
| Oct 24 2006 11:28 AM GMT
| asked by
108108
Database, Oracle, DB2
sql update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment.Eg: The row in question reads '063150987' and I want to replace the fourth...
View Answer
| Oct 6 2006 11:26 AM GMT
| asked by
IdongesitDaniel
Oracle, Database, DB2
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime?Thanks
View Answer
| Jul 10 2006 12:23 AM GMT
| asked by
Columbus
Oracle, Windows, Oracle administration
What is the location of servlets?
I have not been successful in executing a servlet whose physical location is C:MyWorkMyProjectclassesmyServlet.class. In the jsp file I have <form action="../classes.myServlet" method="post">. But, when I run the project within JDeveloper and when tried to execute the servlet, I get "The...
View Answer
| Jun 20 2006 9:15 AM GMT
| asked by
okemos
Oracle Business Applications, Development, HTML
svchost.exe
When I was working with win 2000 advanced server, suddenly it became slower and I started checking the running processes using task manager and I found 4 svchost.exe are running and one of them with PID:916 was using 38000K memory. After sometime the server became normal and everything is OK now....
View Answer
| May 26 2006 6:35 AM GMT
| asked by
BinooDas1234
Business/IT alignment, Project management, AS/400
Using optimizer hints in Forms
Hello everybody.A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me.Can I use the optimizer hints in Forms 6i (program units or triggers) ?Since they look like a...
View Answer
| Mar 13 2006 12:28 AM GMT
| asked by
carlosdl
Oracle, Oracle administration, Performance/Tuning


