How to connect oracle database 8i (personal edition) with d2000 (forms 4.5 & reports 2.5)?
In the laptop how to connect oracle database 8i (personal edition) with d2k (forms 4.5 & reports 2.5) Pls tell me procedure for this connect with database?    

Answer Question   |  August 25, 2010  6:21 AM
Oracle, Oracle 8i, Oracle 8i error messages, Oracle connection error, Oracle connectivity, Oracle Database, Oracle Forms, Windows XP

Oracle Payables Invoice Approval workflow
Hi all, Any one help me to apply Oracle payables invoice approval process. I am very thankfull to you.

Answer Question   |  August 24, 2010  6:42 AM
Oracle, Oracle applications, Oracle Apps, Oracle Processes, Payables

Do you have an IT blog or website and want to earn 100 knowledge points?
We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That’s why we’re asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is geared towards the topics [...]

Answer Question   |  November 8, 2010  8:00 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

How do I recover deleted data from Oracle 9i?
Today morining at 10:30am, user deiete the data, and I have 12 aug, rman full backup, can you help me out with this mess, Thanks Ather Hussain atherhussain9@yahoo.com

Answer Question   |  November 4, 2010  5:24 AM
Backup, Oracle 9i, Oracle 9i Configuration, Oracle backup, Oracle database backup and recovery, Solaris 10

Not able to connect to database through Oracle form builder
Iam not able to connect to database through form builder.How to add an entry for your XE database in your tnsnames.ora file?

Answer Question   |  August 17, 2010  11:21 AM
Oracle connectivity, Oracle Database, Oracle Form Builder, Oracle Forms

What are the most common errors that occur when creating report on crystal report xi by using oracle (SQL) query?
what r the most common errors occurs when creating report on crystal report xi by using oracle (SQl) query.also plz suggest the solutions for thoes errors.

Answer Question   |  August 17, 2010  3:56 AM
Crystal Reports Errors, Crystal Reports XI, Oracle 10g, SQL Query, Troubleshooting

To increase number and combine data using sql
hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = ‘P’ so the output will be :  P-0001 for the next record the output will be : P-0002 any ideas? thanks.  

Answer Question   |  September 22, 2010  3:39 AM
Oracle, SQL, SQL Data Set, TOAD

problem with running oracle 10g form builder
dear all, I am having a problem with running oracle 10g form, I am running windows xp s2 ,oracle database 10g R2 and oracledeveloper suite 10g. I installed Jinitaitor,and all required java programs that are required as I know. the case here,when I run the form my browser show white page ! no errors appears [...]

Answer Question   |  August 20, 2010  9:17 PM
Java applets, Oracle 10g, Oracle 10g error messages, Oracle 10g forms, Oracle Form Builder, Windows XP

How can I run a SAS program in mainframe that calls Oracle in Unix
Hi, I need to run my SAS program in z/OS which call Oracle in Unix to retreive data from Oracle table. I tried this SAS program in PC SAS without any problem. How do I connect to Oracle in my SAS prgram in z/OS? Need help, please    

Answer Question   |  August 13, 2010  7:12 PM
Mainframe, Oracle, Oracle Table, SAS, SAS programming, Unix, z/OS

Migrate from Oracle forms 4.5 to Oracle forms 10g
I have to  migrate the source code from forms 4.5 to Forms 10g. Presently the system is on RHEL 3.5 which is being migrated to RHEL 5 64 bit. For this we have to migrate the forms version also (as I specified above) on to RHEL 5. For this what would be the challenges that [...]

Answer Question   |  August 12, 2010  11:22 AM
Oracle Forms 10g, Oracle Forms 4.5, Oracle migration, RHEL, RHEL 5

Oracle Library cache
What are the steps involved in tuning oracle’s library cache

Answer Question   |  August 12, 2010  6:17 AM
Oracle, Oracle administration

Oracle forms 10g in internet server
How to run oracle 10g in internet server?  pls help me in details

Answer Question   |  August 11, 2010  7:45 AM
Internet Server API, Oracle 10g, Oracle 10g administration, Oracle Developer 2000

Temp table with months in Oracle
how to create temporary table which contains all the months from january to december

Answer Question   |  August 11, 2010  4:31 AM
Oracle, Oracle Forms, Oracle Table, Oracle Tables

How to display non existent data as 0 in Oracle
in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month [...]

Answer Question   |  August 11, 2010  3:37 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table

To display not exit data in oracle
in my table there a,b,c,d are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose b & c are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for [...]

Answer Question   |  August 10, 2010  4:07 PM
Oracle, Oracle commands, Oracle database design, Oracle Table

Connecting and disconnecting Oracle sessions through Oracle forms
How to  connect and disconnect oracle sessions through oracle forms?(suppose I need to validate user whose corrently loged on.)   email to :anandan.muthukannan@tcs.com

Answer Question   |  August 10, 2010  1:31 PM
Oracle, Oracle administration, Oracle authentication, Oracle connectivity, Oracle Forms, Oracle User Profiles

Display date in Oracle Toad
how to display all the months between two dates.my fromdate format is ‘mon-yyyy’ and todate format is ‘dd-mon-yyyy’.plz sugest

Answer Question   |  August 9, 2011  3:07 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler

Calling Oracle Functions from Crystal
We’re stuck on Crystal 8.5 and have a need to call an Oracle function.  That part is solved.  The issue is that it calls it for every record returned in the recordset.  Does anyone know how to limit the call to once?  It doesn’t appear to make any difference in where we place the call; [...]

Answer Question   |  August 9, 2010  6:19 PM
Crystal 8.5, Crystal Reports 8.5, Oracle, Oracle Reports

Standby Database Server
I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don’t know how a user can connect to the standby server when the primary has failed. This is my connection string “Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = [...]

Answer Question   |  August 9, 2010  2:00 PM
Database servers, Oracle 10g, Oracle Database, Standby Database, Standby Server

ordering dates in Oracle
how to order the months and year in descending order from a table?suppose there are 2 culomns one contains month and another contains year.then how to show them in an order like jan-2001,feb-2001,mar-2001………like this. plz suggest some answer for this.

Answer Question   |  August 9, 2010  3:49 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table