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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
the problem is, its is connecting but there is a packet checksum failure… please help us out. thanks. by the way, my email is firstname.lastname@example.org
Answer Question | October 7, 2009 5:21 PM
ODBC Errors, Oracle 9i, Oracle Forms
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
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