Answer Posted / ashis
View is a virtual table or logical table or it can be
represented as mirror if table.View allows performing
transaction on table virtually.Table may contain "n" number
of views.View can be based on single table or more than one
table with help of join.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the use of aggregate functions in oracle?
Explain the use of record length option in exp command.
Use of an integrity constraint is better to validate data. Explain
What do you mean by merge in oracle and how can you merge two tables?
What is the difference between sharding and partitioning?
How to run queries on external tables?
Is rowid unique in oracle?
How to add a new column to an existing table in oracle?
What is the purpose of save points in oracle database?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Write a syntax for update query in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Explain coalesce function?
How to write a query with a left outer join in oracle?
Difference between hot backup vs. Cold backup?