|
Can anyone point me to some good references online where I can learn about Oracle databases?
Answer Snippets (Read the full thread at stackoverflow):
I useYou can try the Oracle website ( http://www.oracle.com/technology/documentation/database.html ) there are lots of documentation....
Without further information, I would recommend beginning with Oracle Database Concepts .
Be found.
|
|
I'm looking for a hosting provider of IIS/ASP.NET sites that also allows access to Oracle databases (at a minimum they'd need to install the Oracle instant client plus Oracle ODBC drivers). Any ideas?
Started by tmcallaghan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
I personally have not hosted an Oracle database before, however, I do host RIA Service (Silverlight 3 "probably" allow you to install Oracle db and Oracle ODBC driver in case you have a decent budget that they are very flexible....
|
|
I have access to an Oracle server that has some databases that I would like to access. However, the machine that I have access from has none of the oracle client software. Is there any alternative to oracle's client software the provides the functionality...
Started by Paul Wicks on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use that without doing any sort of Oracle client install which will....
If you download the free Oracle Instant Client you'd be able to use any JDBC or ODBC Database tool of databases, obviously including Oracle.
|
Ask your Facebook Friends
|
Is there a tool that allows me to change my password in multiple Oracle databases?
It expires every month and I would like to change them all simultaneously.
Started by Jack on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
In ....
So ...
This used to work.
You could change your password in 1 database (I haven't done this in a number of years - so try this carefully - Last time I did this was 7.3.4 and 8i) then copy the hash from database to database.
|
|
Where can I query the current case-sensitivity setting of an oracle database?
I've tried looking in v$database , nls_database_parameters , and looking through the system packages, but none of them seem to provide the information I need...
Answer Snippets (Read the full thread at stackoverflow):
Values:
BINARY
Normally, comparisons is for backwards compatibility; in general....
In Oracle 10gR2 :
SELECT * FROM NLS_SESSION_PARAMETERS WHERE parameter IN ('NLS_COMP', 'NLS_SORT_COMP specifies the collation behavior of the database session.
|
|
We are designing a fairly large brownfield application, and run into a bit of a issue.
We have a fairly large amount of information in a DB2 database from a legacy application that is still loading data. We also have information in an Oracle database ...
Started by MattGWagner on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can also use this database linkI've done this two ways....
This makes it possible to query your DB2 database real time and you can join a Oracle table with a DB2 table.
You create a database link from Oracle to DB2.
|
|
Basically, I'm trying to selectively copy a table from one database to another. I have two different [Oracle] databases (e.g., running on different hosts) with the same schema. I'm interested in a efficient way to load Table A in DB1 with the result of...
Started by Jacob on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Maybe you can just select across the database link..
Create database link other_db connect;
You may not even need to move that data.
Use a database link, and use create table as select.
|
|
What is the best approach to build a small (but scalable) application that works with Sql Server or Oracle?
I'm interested in build apps that supports multiple databases, in the process behind the feature.
Started by Jonathan on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
That way you should just have to swap out the database....
You could look at either NHibernate or Entity framework for example - both have oracle and sql server support.
Using an ORM that supports multiple databases is the first step here.
|
|
Hi,
I am new to Oracle. Since we have rewritten an earlier application , we have to migrate the data from the earlier database in Oracle 9i to a new database , also in 9i, with totally different structures. The column names and types would be totally ...
Started by Chakravarthy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
As most Oracle products it is powerfulIn many cases, creating a database link and some scripts a'la
insert into newtable select distinct database....
In the Database licence and you can download it from the Oracle website.
|
|
So many companies today want someone with Oracle experience. I have none, but it seems to me that it shouldn't be hard to figure out quickly. However, when potential employers ask me if I've worked with Oracle, the line "No, but I'm an expert with Microsoft...
Started by Joshua Carmody on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
Stick an MS....
Once this for you), working with Oracle is barely distinguishable from any other database, so I would and it's guis.
Server devoted entirely to an Oracle database with two tables with a few hundred records each.
|
