JAVA with 4+ experience – Need to change my career way path completely
All careers paths have varying degrees of stability, but from a general perspective the most stable careers are the ones that are very specialized. This is a double-edged sword in that you will be very restricted in terms of mobility depending on the specialization you elect. Also it generally is very hard to get into [...]

View Answer   |  January 28, 2011  7:06 PM
CRM, Java, Oracle CRM, SAP careers

Oracle opportunities
For PL/SQL, please link <a href=”http://plsql-tutorial.com/”>Here</a> For SQL, please link <a href=”http://www.sql-tutorial.net/”>Here</a>

View Answer   |  January 28, 2011  9:37 AM
Oracle, Oracle PL/SQL, Oracle projects, SQL

Upgrading for database structure
the best way to to this upgrade, is to use an ETL like Talend ou Informatica. Talend is an open source we use it for our data migration. for more informations you can visit talend web site best regards

View Answer   |  January 25, 2011  9:50 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server

Application Upgrade and Data migration
The best practice for migration of data from one database platform to another database platform, involves first understanding and mapping your data and then ensuring that you are not using database specific features and if you are then to remap the relationship to a schema or set of schemas that your new database platform will [...]

View Answer   |  January 24, 2011  9:36 PM
Database, Development, Oracle, SQL Server, Web application development

How to call report 6i from forms6i defining the username/password
report call from form6i declare pl_id parameter; n number; begin pl_id:=get_parameter_list(‘parameter_list’); if id_null(pl_id) then pl_id:=create_parameter_list(‘parameter_list’); ——————parameter add form to report—————————————————– add_parameter(pl_id,’Emp_code’,tex_parameter,:block_name.employee_code); ————————————————————————————————————– –’emp_code’ is a report parameter.. –employee code is form text column name , taki form k through report me value jaye. —————–run report——————————————————————————– run_produc(reports,’c:report_name.rdf’,syncronous,runtime,filesystem,pl_id,null); end;

View Answer   |  January 24, 2011  10:20 AM
Oracle, Oracle Forms, Oracle Forms 6i, Oracle Reports, Oracle Reports 6i, Oracle User Profiles

Are Oracle direct queries straightforward?
write a query to desplay names and higher date of all the employee who where higher in the year 1985?

View Answer   |  January 23, 2011  2:24 PM
Database Application, Excel 2000, Oracle, Oracle Query, Windows Server 2003

Not able to access Oracle forms 10g from client through web.
http://web1:8889/forms/frmservlet is not the URL of your form. That is the address of the forms servlet. You don’t run the form accessing that URL, you run the form from the IDE and that is the address you see in the browser, which is a little different. If you want to access your forms from other [...]

View Answer   |  January 18, 2011  5:42 PM
Oracle 10g administration, Oracle Database 10g, Oracle Developer 10g, Oracle Forms 10g

Connect to Oracle 10g with VB6 using ADO
One thing that is not clearly specified in the above article is that you need to have Oracle client software installed. The following article may help as well: Displaying an Oracle 10G XE Table with Visual Basic 6.0

View Answer   |  May 8, 2013  4:45 PM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6

Oracle 10g – WEB.SHOW_DOCUMENT parameters
<b>’_self’</b> Causes the document to load into the same frame or window as the source document. <b>’_parent’</b> Causes the target document to load into the parent window or frameset containing the hypertext reference. If the reference is in a window or top-level frame, it is equivalent to the target _self. <b>’_top’</b> Causes the document to [...]

View Answer   |  January 17, 2011  5:11 PM
Oracle 10g, Oracle default parameters, Oracle Forms, Oracle Forms 10g, Web.Show_Document

Call parameter from Oracle Reports 10g web.show_doc
You will probably need to run the report using the RUN_REPORT_OBJECT built-in procedure before calling web.show_document, and I would recommend to do it that way, so you don’t need to compromise security including the database connection information in the URL. This is an example: <pre>declare good luck repid REPORT_OBJECT; Rashid Shah v_rep VARCHAR2(100); rep_status VARCHAR2(20); [...]

View Answer   |  January 17, 2011  3:43 PM
Oracle 10g, Oracle development, Oracle Forms 10g, Web.Show_Document

Oracle Forms 10g- which is the correct one to use- NEW_FORM or CALL_FORM?
NEW_FORM exits the current form and enters the indicated form. The calling form is terminated as the parent form. If the calling form had been called by a higher form, Oracle Forms keeps the higher call active and treats it as a call to the new form. While CALL_FORM can call the other form. But [...]

View Answer   |  January 17, 2011  12:06 PM
Oracle 10g, Oracle Forms, Oracle Forms & Reports Developer 10g, Oracle Forms 10g

Oracle 9i error message in Windows 7: jrew.exe
Windows 7 doesn’t support Oracle 9i that is why u will get the error message. May be Oracle 9i have still not come up with the updated patches/drivers for Windows 7. For more information and guide, please register Here.

View Answer   |  October 11, 2012  5:31 AM
Oracle 9i, Oracle 9i error messages, Oracle error messages, Windows 7

Oracle Reports Builder
I understand what you are saying. You are gettign multiple identical records returned from your query. A way to get around this prblem is : Lets say your Query is as follows: SELECT …… group by ….. What you coudl do is to do it like this: Select …… from (your original query) group by…… [...]

View Answer   |  January 14, 2011  9:41 PM
Oracle development, Oracle Reports, Oracle Reports 6i, Oracle Reports Builder, SQL Query

How to use POS.NET for a BARCODE SCANNER in a VB.NET application
For a real simple solution, use a “keyboard wedge” scanner. These are scanners that plug into a USB (or serial) port and simulate the user typing in the value of the scanned barcode, followed by a (usually programmable) carriage return/line feed. In the application, you set focus to a text field, then the user clicks [...]

View Answer   |  January 12, 2011  1:15 PM
Barcode scanners, Oracle Database, VB.NET

Replicating Oracle 10g database in Oracle 9i
Oracle does not support replication from a new version of their database to an older version. However and there is the caveat that you are not using features that are only supported in Oracle 10g then you should be able to use the Oracle import/export utilities to migrate your data from Oracle 10g to Oracle [...]

View Answer   |  January 6, 2011  2:56 PM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle Database, Oracle Database Versions

Backup solutions for VMware environment
Worse comes to worse, you can just install the current TSM agents on the VMs within the VMware environment and backup the VMs as if they were physical machines until you can upgrade your TSM system so that you can backup the VMs via the host.

View Answer   |  January 3, 2011  10:01 PM
Desktop virtualization, ESX 3.5, ESX 4.0, Oracle Database, RedHat, Server virtualization, SQL Server 2005, vCenter 4.0, VMware, Windows Server 2003, Windows Server 2008

How to connect Forms 6i with MS Access
Rashid bhai Aslam-o-Alaikum, have you gotten the solution of problems. if u have please send me at my email address tnx. Asif Majeed asifmajeedsahal@hotmail.com

View Answer   |  January 2, 2011  6:27 AM
Microsoft Access, Oracle 6i, Oracle Forms, Oracle Forms 6i

Can i use two parameter in oracle report
I don’t know of an easy way to do that in the Report’s parameter form. Lists of values from parameter form’s items don’t allow the use of bind variables (parameters) by default, and AFAIK you can’t change the LOV’s query at runtime. However, there is a way to do it using the Reps_UTL.pll library, but [...]

View Answer   |  December 24, 2010  3:35 PM
Oracle developers, Oracle development, Oracle Reports, Oracle Reports User Parameters, Parameters

How to export the excel file in oracle
U can make a text file, (creating with comma separated) from excel and then load the data in the text file into oracle using sqlldr (sql loader).

View Answer   |  December 24, 2010  12:36 PM
Oracle, Oracle 10g, Oracle 10g administration, Windows XP

Problems installing Oracle 9i in Windows Vista
Because Oracle 9i is not supported on Windows Vista.

View Answer   |  December 23, 2010  2:20 PM
Oracle 9i, Oracle 9i installation, Oracle 9i installation errors, Oracle installation, Windows Vista