connecting to db - Oracle vs MS SQL

[Mikey Kelly]

Hi,
When I connect to my MSSQL database I specify the database name in the url:

jdbc:jtds:sqlserver://<ipaddress>/<dbname>

So I don't have to give the database names in the queries. When I connect to Oracle (haven't tried it yet!) I specify the SID in the url:

jdbc :-o	 racle:thin:@<ipaddress>:<port>/<SID>

I presume that the SID is one value for the whole database server? If so, when querying my Oracle database, do I have to specify the database name everytime in the query? eg.

myQuery = "INSERT INTO myDatabaseName.students (userName) VALUES ('userName')";

instead of simply:

myQuery = "INSERT INTO students (userName) VALUES ('userName')";  

Thanks for illumination...
Mike

[Paul Sturrock]

I presume that the SID is one value for the whole database server? If so, when querying my Oracle database, do I have to specify the database name everytime in the query? eg.

Depends who you connect as and how you set up your schema. Do you have a DBA near you, or are you setting this up yourself? If you don't have a DBA, you will need to read through the "Oracle Database Concepts" documentation which can tell you all about users, roles, privileges, schemas, synonyms etc. Otherwise you will find Oracle very hard to use.
[ August 30, 2005: Message edited by: Paul Sturrock ]

[Jignesh Patel]

You don't need to use username before the table name, if you are accessing as a user who owns tables.

[Mikey Kelly]

OK,
I will look into the documentation mentioned.
However, sounds like if the user account I use has "ownership" of the tables in question, with appropriate privileges, I don't need to specify the table name...?

Thanks,
M