Display Report Preview on full screen
When a report is executed the output is not displayed in full screen. the end user has to use the maximize button to do so. I would like to have the report displayed on full screen Software/Hardware used: Oracle 10g - Report 6i
When a report is executed the output is not displayed in full screen. the end user has to use the maximize button to do so. I would like to have the report displayed on full screen Software/Hardware used: Oracle 10g - Report 6i
10 pts.
The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...
MS SQL Server to Oracle Applications
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal...
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal...
Upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
How does one upgrade the Oracle Client to 10i from 8.1 without losing database connectivity? Software/Hardware used: Oracle Client 8.1
How does one upgrade the Oracle Client to 10i from 8.1 without losing database connectivity? Software/Hardware used: Oracle Client 8.1
Extract data from dmp-file without Oracle
I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me...? Software/Hardware used: Oracle
I need to extract data from a large ORACLE dmp-file (many users, many tables). My idea is to get in TXT or CSV. However, NXTract could not manage this because of the size (buffer overflow error). Is there any other tool out there that can help me...? Software/Hardware used: Oracle
Difference between JDE one world and JDE Eone 9.0 for procurement
I was asked by client for the question. Does anyone can provide some input for me?
I was asked by client for the question. Does anyone can provide some input for me?
Getting error while insert in forms 6i application
hi, i have a database block on my form. the table to which it belongs is having one field naming - 'RETURN' . so at the time of insertion it is giving error as Oracle error-Unable to insert record' and the error is unique constraint violated, but at the same time the record is getting inserted into...
Answer Question
| Nov 13 2009 11:01 AM GMT
Oracle Forms 6i, Oracle Forms, Oracle Forms Error Messages
hi, i have a database block on my form. the table to which it belongs is having one field naming - 'RETURN' . so at the time of insertion it is giving error as Oracle error-Unable to insert record' and the error is unique constraint violated, but at the same time the record is getting inserted into...
Answer Question
| Nov 13 2009 11:01 AM GMTOracle Forms 6i, Oracle Forms, Oracle Forms Error Messages
pl/slq procedures - POSITIVE and POSITIVEN as IN OUT parameters
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a...
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a...
The IT Blog Top 10: Nov. 12, 2009
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
Oracle Certification?
Hi, I want to know, the total procedure for Oracle data base certification. Thanks
Hi, I want to know, the total procedure for Oracle data base certification. Thanks
Lotus Domino Data Connection Resource (DCR)
Is it possible to setup Lotus Domino DCR to query data only? Another word, lookup data using two keys and return third field from a Oracle server. Version ND8 and Oracle 10G Software/Hardware used: Version ND8 and Oracle 10G
Is it possible to setup Lotus Domino DCR to query data only? Another word, lookup data using two keys and return third field from a Oracle server. Version ND8 and Oracle 10G Software/Hardware used: Version ND8 and Oracle 10G
The IT Blog Top 10: Nov. 5, 2009
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...
Suggestions regarding OCP
Hello friends, I am a 5th semester student of BTech/BE(Computer Science & engg) student.I have studied database management system subject in my course syllabus at college and now I wish to take OCP test.During my study I referred to Database System Concepts by Korth,Sudarshan & Silberschatz (McGraw...
Hello friends, I am a 5th semester student of BTech/BE(Computer Science & engg) student.I have studied database management system subject in my course syllabus at college and now I wish to take OCP test.During my study I referred to Database System Concepts by Korth,Sudarshan & Silberschatz (McGraw...
Calculating concurrent users based on active members in DB
Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...
Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...
The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
SAP Oracle DBA security privileges
What roles, privileges, transactions should we allow the Oracle DBA to use and access. Presuming DEV-PROD. Were moving the DBA role out of the BASIS group. We know all DB.. transactions, plus ST22, and looks like SE11 and SE16 are suggested. Thank you for your help. Software/Hardware used:...
What roles, privileges, transactions should we allow the Oracle DBA to use and access. Presuming DEV-PROD. Were moving the DBA role out of the BASIS group. We know all DB.. transactions, plus ST22, and looks like SE11 and SE16 are suggested. Thank you for your help. Software/Hardware used:...
Oracle table update exist ?
dear all, i want implemente a update on many table but i don't know the syntax please help me. My update is at less on 5 table
dear all, i want implemente a update on many table but i don't know the syntax please help me. My update is at less on 5 table
isa server 2006
I install isa server 2006 internet is working fine but i enable isa client firewall in client side that time externel email working but oracle application not working when i disable isa client firewall externel email not working but oracle application is working fine i want working both oracle...
I install isa server 2006 internet is working fine but i enable isa client firewall in client side that time externel email working but oracle application not working when i disable isa client firewall externel email not working but oracle application is working fine i want working both oracle...
How to convert LONG to CLOB or to VARCHAR type in select statement
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
