|
|
Browse by Tags
- .NET
- date
- null
- Oracle 10
- Oracle Client
- Pl Sql
- scripting languages
- Shell Script
- TOAD 9
- Visio 2007 Professional
- Vista x64
-
How do I configure the Microsoft Loopback Adapter to install Oracle 11 on Vista?
I get this message when attempting to install Oracle 11: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. How do I do this? Thank you for your interest... -
how do i recreate listener oracle 11g
i am unable to connect toa db lsitener. I need to delete it and restart i all over. How can I do it? -
update one date field with another, for the same key
Experts, I have a temporary table filled with history data from the source. Ultimately I need to load it to a real table, but only after I figure something out. I have multiple records per class ( rtclas ), but they are distinct when you factor in effective_date ( which is rtmnth, rtday, and rtyear concatenated... -
Joining a portion of a table to itself
Experts, My ultimate goal is to load my source data, which is now in a temporary table, into a main table in the DB. I have figured out that only some of our new data ( which is history ) needs to be loaded to the main table ( as much of the information is already on there ). In fact I know that only... -
unlock and unexpire oracle accounts through script
Hi all, I like to create a small unix shell script to unlock and unexpire all the expired and locked user accounts. example: >./myscript.sh the above command has to unlock and unexpire the expired and locked user accounts i like a interaction script also, example : >./myscript.sh -i then it has... -
Find max effective date in subquery
Folks, I am trying to pull records out of a temp. table I have set up containing my input data from my source and update my ultimate table with it. There are multiple records per class ( column name rtclas ), but each effective date is unique per each class. I am concatenating the effective date from... -
convert number columns to a date and get max
Experts, I am sure this is an easy one, just not for me. I have 3 columns, all numeric. a two byte day, a two byte month, and a four byte year. I want to ultimately concatenate them into a date, with a format of mm/dd/yyyy. I got the data initially in a spreadsheet and then imported it to a temp table... -
How can I use Visio 2007 to reverse engineer an Oracle 11 database on Vista x64?
I'm running Vista 64 in a bootcamp partition on my MacBook Pro, accessing that partition through VMWare Fusion. I'm able to install Oracle 11 (after fixing the stupid loopback connector) and can connect to is fine. I also installed Oracle 10G later. I can't reverse engineer either database... -
Problem: Confusing Date Parameters
Experts, I will try to make this note not as confusing as my brain feels it is. Basically, I inherited some reports to test, and one of them blows up when run on the front end, sometimes. The query takes 2 parameters, a From_Date and a To_Date and uses both of them as parameters in the subquery as Effective_Date... -
Problem: 'Oracle.DataAccess, Version=2.111.6.20 System Cannot Find the File Specified
I am trying to run a program that was developed by another party. The program is a C#.NET application that was developed against an Oracle 11 database and Oracle 11 Client/SDK. The machine I need to run the program on has an Oracle 10g client and when I try to run the program I get the following unhandled...