Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert, Update and Delete within collection

Ambuj KumarOct 8 2018 — edited Oct 8 2018

Within Oracle database, Collection can be used in "Select" with help of TABLE operator. But we can not perform insert, update and delete as we can do with relational table. At least if we would be able to perform update then it will make data manipulation fast and easy and It will be very cool feature to have.

Comments

unknown-7404
You should not do this.

Environment variables such as PATH can only give preference to one item of any given name. With DLLs for example the first DLL of any given name that is found will be the one loaded by Windows. It would be up to the software doing the loading to determine if that is the correct version and most software just looks by name.

That is what is known as 'dll hell'; the wrong version of a dll is being used.

You don't need both clients installed so why do you want to do that?
Pl identify which version of Win 7 - you will need Professional or higher. Pl also identify which exact version of Oracle client.

I have no personal experience with this myself, but the 11gR2 docs say you can install both the 32-bit and 64-bit clients as long as you use different ORACLE_BASE directories.

http://docs.oracle.com/cd/E11882_01/relnotes.112/e23557/toc.htm#CJADGJDB

HTH
Srini
Helios-GunesEROL
Hi;

By using different path yes you can install.

Please review:
Master Note For Oracle Database Client Installation [ID 1157463.1]
Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]


Regard
Helios
941843
Windows 7 Enterprise

Oracle Client 11g (11.2.0.1.0)
941843
Doesn't this write both ORACLE_HOME paths to the PATH environment variable, and then cause, as mentioned above, DLL hell? With WOW64, it is unclear to me how Microsoft separates 32-bit paths from 64-bit paths.

Unfortunately, my company is running 32-bit Microsoft Office 2007 and other 32-bit programs that use the Oracle thick client install, and my company also uses 64-bit programs that require the Oracle thick client install too.

The solution thus far has been to uninstall one of the programs, and thus clean-up the %PATH% environment variable; or rearrange the order of the Oracle client homes in %PATH% to make the broken one work.
941843
After researching the links, this was still unclear if the 2 clients would conflict with each other.
1 - 6

Post Details

Added on Oct 8 2018
3 comments
319 views