• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

Database question???

 
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
I have installed oracle on my c:\ drive and created database for example of name 'abc'.
now when i go to sqlplus editor and create
a table 'customers' and i do desc command i see all its columns,the question is: is that table 'customers' now in that database 'abc'?
How do i know that?is there a sql statement to show me all tables in that database 'abc'?(sample code plz).
I'm sure i can create many databases too other than 'abc' ...is that right?
To connect to 'abc' is database url should be like the following:
"jdbc racle:thin@localhost:1521:abc"
is that right?
Thanks for your time.
 
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Somebody jump in here and correct me if I'm wrong but in Oracle the databases are actually namespaces and they are defined by the owner. So to see all tables in one namespace, you can query the all_tables view:
SELECT table_name FROM all_tables
WHERE owner = 'adam'
 
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi,
The sql statement is "select * from tab"

MSM
 
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Try this query
"connect username/password @database name".
Then type "select * from tab".It will show u the tables available in that database.
Regards,
Murali
 
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Search this form for code examples.
I have posted Oracle, DB2, CloudScape, and MS-Access examples.
Search this form for Monty or Monty6
Start you search around Sept of 2001
You may have to go back about 6 to 12 months.
You should be able to find the anser to your question(s) in one of my code fragments.
Hope this helps
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic