How do we keep an accurate inventory of Oracle licenses for DB technology & E-Business Suite. what audit mechanism are available & how to maximize the use of existing licenses without having to pay for extra licenses.
Oracle licensing, Oracle Business Applications, Oracle E-Business Suite
How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE...
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 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...
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 C....
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...
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
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...
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....
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...


