What is the difference between an Oracle Schema and an
Oracle Instance?
Answer Posted / udayah shankar dokku
oracle schema: generally it is static,having tablr
name,column name & associated datatypes
oracle instance : generelly it is dynamic,at ay instance of
time the collection of all records is called oracle instance
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to see the table columns used in an index?
Is there any function in oracle similar like group_concat of mysql?
What the is the diff between local index and global index. give some example.
Can we call procedure inside function in oracle?
How to sort output in descending order in oracle?
Design database draw er diagram for a certain scenario ?
What is the data pump import utility?
How to get execution path reports on query statements?
How to create a testing table in oracle?
How to invoke the data pump export utility?
What is format trigger?
What is a lookup table in oracle?
How a database is related to tablespaces?
How many types of database triggers exist?
How to use values from other tables in update statements using oracle?