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.
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'
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
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