Oracle 10g

Equivolent HLOOKUP using SQL

I am a beginner at SQL... I've come across a situation maybe someone can help me out. I have a table with the following structure: bkt_id am bkt_101 bkt_102 bkt_103 ... bkt_228 bkt_101 $100 $100 $20 $0 bkt_102 $50 $100 $20 $0 ... I want to compare am with the proper bkt_n...

How to convert character report to bitmap

Hi, I want to convert oracle 10g character (.txt) report to bitmap (.pdf) in A4 size. The existing character report is 13inches X 11inches.

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

cloning oracle 10g database

is anybody help me out i am a jr entry level oracle dba ,cloning a oracle database on windows os cloning on same host.

calling report for printing from oracle 10g developer

i am using oracle 10g developer. i want to call a report with parameter from menu and also want to see print preview as well as to do print. how can i do it?

Export to .doc from Oracle

How do I export a report report containing tables from Oracle 10g to .doc format.I would like to manually edit some of the contents of the .doc file

Will Maximo 5.2 work with Oracle 10g?

I am researching to see if we can upgrade to Oracle 10g without upgrading Maximo 5.2 at the same time. We are currently running Oracle 9.2.0.8 which is scheduled to have the terminal patch released July of 2010.

Oracle Privilege error

I am using Oracle 10g and does the following. Scheduling a job (procedure call) from my application. Procedure is querying synonyms of another schema and the schema is given the select privilege on all synonyms. When the procedure is executed directly, it works fine. But when scheduled as a job...

I am not getting source of oracle.I searched a lot but was not able to get it from anywhere.Plz help me.

And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only

SSRS 2008 - Connection to Oracle 10g seems to be timing out

I'm running SSRS 2008 via Visual Studio on my desktop. The data source for my report is an Oracle 10g database. The report runs fine when the parameters are set to limit the number of rows returned, but when I change them to return more data it eventually times out. The same query runs in less than...

Problem running Oracle Forms 10g in browser

I am unable to run the form in the browser I have set the run time preferences

Errors Registering Recovery Catalog in 10g Grid

I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a...

How to determine the number of concurrent processes in Oracle 10g

How can I find out the number of concurrent processes at any point of time in 10g database

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

View .pdf file from Oracle Forms 10g

Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...

Oracle 10g will not download to my Vista client machine

I have ThomsonTechnology Textbook Oracle 10g Database Administrator Implementation and Administration IBSN:-13 978-1-4188-3665-8. Oracle OTN website will not log on my Vista machine. I have been able to download Oracle 11g sucessfully.

Take print of a report from Oracle 10g Form

how can i take print of report from Developer 10g Form.

Call parameter from Oracle Reports 10g web.show_doc

the code DECLARE rep_url varchar2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=c:\testrpt10g.rdf' ||'&desformat=htmlcss&destype=cache' ||'&userid=stlexport/stlexpst@as'; WEB.SHOW_DOCUMENT(rep_url,'_blank'); END; is running well. But now i want the report's parameter form to be displayed....

Windows performance setting for Oracle

We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram. The factors I'm looking at at the OS level is: - Paging: system...

store data from report10g to database

how to use srw.get_page_num(...) and store the number in database