• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connecting to db - Oracle vs MS SQL

 
Mikey Kelly
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
When I connect to my MSSQL database I specify the database name in the url:



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:



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.



instead of simply:



Thanks for illumination...
Mike
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 626
Mac
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You don't need to use username before the table name, if you are accessing as a user who owns tables.
 
Mikey Kelly
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic