Answer / guru

View: View is a virtual table, a query attached to it.
Actually it have not Stored query results. It will execute
and returns rows.

A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.A materialized view can query tables, views, and
other materialized views. Collectively these are called
master tables (a replication term) or detail tables (a data
warehouse term)

Answer / rahul khanke

views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..

Answer / a.jyothsna

VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query

Answer / pinkey

A view is just a stored query and has no physical part.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache. A materialized view has
a physical table associated with it; it doesn't have to
resolve the query each time it is queried. Depending on how
large a result set and how complex the query, a
materialized view should perform better.

Answer / naresh

View: - it is logical table,it doesn't contain any data,it's contain only select statement.
if you modify the data in view,it's immediately effect to the Base table.
it gets rowids same as the base table.
Materialized view: - M.V are mostly use in Data Marts.

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

How do you retrieve the second highest salary from a table?

3 Answers  

Is sql dba a good career? : SQL DBA

0 Answers  

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

Is left join same as inner join?

0 Answers  

Does sqlite need a server?

0 Answers  

What is database migration?

0 Answers  

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

What is fmtonly in sql?

0 Answers  

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,