Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 9141 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishal
for simplicity, Instance is the name of the Database.
Schema is the owner of your objects(tables, indexes, views,
synonyms,etc).
In you example, you have a Database Instance named
CONTRACT.
In your Contract database, you have 2 Schemas named LEGAL &
RI
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / saiprasannach89
A user in oracle database is called as schema.Objects created by user is called schema objects.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / 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 |
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
what is insert all statement in sql
Is there a function to split a string in plsql?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Why do we use coalesce function in oracle?
What are the uses of Rollback Segment ?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
what is integrity constrains?
How to open a cursor variable?
What is the Tune Query
What is BBED in Oracle?
How do I learn what codesets are available in oracle?
Oracle General 
