Bulk update for every 10k rown among 2L
Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this

Answer Question   |  October 22, 2009  1:43 PM
Oracle, Oracle Database, Scripting

calling trigger in oracle db 10g
hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows’ history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I’m waiting for your help.                   Thanks!

Answer Question   |  October 16, 2009  7:32 AM
ASP.NET 2.0, C#, Oracle 10g, Oracle Database, Oracle Database 10g, Oracle developers

Oracle 10g Unable to connect the Report server
Im using forms 10g and reports , i have deployed forms and reports in internet explorer, im able to open the forms from the menu, but Reports its shoing unable to connect, i have created batch file for report to start automatically, still it is not connecting, im getting the same error, i guess i [...]

Answer Question   |  March 31, 2010  3:20 PM
Oracle 10g, Oracle error messages, Oracle Reports, Oracle Reports Server

Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Members who have earned over 1,000 Knowledge Points in the community by December 15th have the opportunity to cash in their points for Amazon gift cards — just e-mail us at contactus -AT- itknowledgeexchange.com with your handle when you choose to cash out. You can also post here in the discussion area when you’d like [...]

Answer Question   |  April 3, 2012  2:32 PM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP

Oracle 10g Acessing the Mapping between Sequences and tables
How to Find out the List of table name using or sharing any sequence in oracle Is there any Provision in Oracle 10g or upper versions

Answer Question   |  May 3, 2010  1:04 PM
Oracle, Oracle 10g

The most-watched IT questions this week: Oct. 13, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: [...]

Answer Question   |  October 14, 2009  1:37 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

How do I concatonate the data from the same field from multiple rows
I need to concatonate data from the same field with multiplre rows witha one to many relationship. As and example: oder_id     product 503          corn  503          beans 503         apples the end result wanted would be asingle row order_id      products 503            corn, beans, apples

Answer Question   |  October 13, 2009  5:34 PM
Oracle 9, Oracle 9 Database, Oracle Data Access, Oracle Developer

Print Context ID Report in version 3.5.1
Can someone please tell me how to print a context ID report in UPK version 3.5.1?  I used to be able to get one in a previous version but despite much searching cannot find one in the newer version I have now. 

Answer Question   |  October 12, 2009  3:54 PM
Oracle, UPK

Converting FMX to FMB in Oracle 6i version
Hi All, As I have lost my FMB file, i wanted to convert to FMX to FMB. How do we convert FMX to FMB? Is there way to convert? Please give the steps do so.

Answer Question   |  January 11, 2011  11:35 AM
FMB, FMX, Oracle 6i, Oracle Developer, Oracle Developer 2000

Content Canvas
How Can I Arrange Or Design The 60 Items With Displaying 10 items at a time.and others are accessible through scrollbar.Rememeber That We Don’t Have To Use Stacked Canvas ?

Answer Question   |  October 12, 2009  4:39 AM
Oracle Developer, Oracle Developer 2000

Using Property Class
How Can We Set The Property of An Property Class Runtime in D2k ?

Answer Question   |  October 12, 2009  4:33 AM
Oracle Developer, Oracle Developer 2000

Exporting Oracle 9i tables
I have installed Oracle 9i server on Windows 2000 and clients on other machines. The database name is admin. I have created tables in my own login ora102 on the client machine. Now I want to export the tables which I have created in my own login. I used the following command on theclient machine [...]

Answer Question   |  October 9, 2009  3:27 PM
Oracle 9i, Oracle export, Oracle Tables

Microsoft Server 2003 to Oracle migration
Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.

Answer Question   |  October 13, 2009  3:23 PM
Microsoft Server 2003, Oracle Database, RHEL, RHEL 5

ORA-02019: Connection description for remote database not found
I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of [...]

Answer Question   |  October 9, 2009  3:22 PM
Oracle Database, Oracle database administration, Oracle error messages

Oracle 10g Database transfer
How can I transfer Oracle 10g Database under Windows to Oracle 10g under Linux? What precautions need to be taken?

Answer Question   |  August 12, 2011  3:20 PM
Oracle 10g, Oracle 10g Database, Windows Server

ORA-31672 in oracle 11g
Getting Oracle Database Error Code ORA-31672 Worker process string died unexpectedly. Any quick fixes

Answer Question   |  October 8, 2009  2:38 PM
Ora-31672, Oracle 11g, Oracle Error Codes

Data issue in a Oracle Table
I have a 180 GB size table. When I select the table,it returns some columns with null data. But if I Select that particular record showing NULL column with a Primary key filter,it is showing data for that column. Please let me know what might be the problem with that table.

Answer Question   |  October 9, 2009  8:55 AM
Oracle Tables, Oracle Tablespaces

connecting oracle forms to mysql
the problem is, its is connecting but there is a packet checksum failure… please help us out. thanks. by the way, my email is lance_arch_angel@yahoo.com

Answer Question   |  October 7, 2009  5:21 PM
ODBC Errors, Oracle 9i, Oracle Forms

Soon you can redeem knowledge points for Amazon.com gift cards
Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering [...]

Answer Question   |  June 16, 2012  4:53 PM
AS/400, Channel, CIO, CRM, Data Center, Database, Development, Exchange, Linux, Lotus Notes, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows

Auto tool for load/perform testing Oracle10g applic.
Financ. appl (client/server) based on Oracle6i must be migrated to Oracle10g (Web). Now at stage of analysing/estimating the proper auto tool for load/performance testing. Any advices or sources, please. Thanks in advance.

Answer Question   |  October 6, 2009  4:08 PM
Oracle 10g, Oracle 6i, Software testing, Software testing tools