• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

connecting to db - Oracle vs MS SQL

 
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 681
Mac
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
what if we put solar panels on top of the semi truck trailer? That could power this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic