I want to connect oracle from excel 2010.
My requirement is as below:
My machine has oracle client installed but the excel file needs to be distributed to approx 200 people.Those people does not have oracle client installed.
I want that instead of mentioning service name (which resolves through my tnsnames entry defined in my local machine), connection should use database host name(IP Address) and DB name.
I do not know how to do this.
Pls. give me step by step instruction for doing the same
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …