Answer / sreekanth

No, View is a logical table associated with a query.
It will not store any data in it.
Only the query with which the view is created is stored in
the database.

Answer / sekhar

Absolutely, the view contain no data. The basic property of
a view is to extract a set of data columns to display from a
large number. And this is useful in future by jst stating
the view name instead writing the select statement every time.

Answer / gvmahesh

NO,the view is a logical table based on one or more tables
or views.A view in practicality contains no data by
itself.it contains only select statements.

Answer / shail

Hold on!!!!

All the above answers are absolutely true but remember the
fact that if you delete or update any view data then it
will be reflected in the base table.

Answer / ram

hold on..
all above are correct
incase of simple view dml operations are allowed
(simple view mean view creates based on one table)

incase of complex view dml operrations not allowd
(complex view create based on more than 1 table)

one more thing is in oracle
materialized view maintain physical copy of data
(dml operations on base tables not reflect on materialized view)

Answer / suresh

View is a stored select statement,it does not contain any data,and it is a logical table just for the viewing purpose

Is sql the best database?

0 Answers  

Does pl/sql support create command?

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

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.

2 Answers   Oracle,

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

How do I turn a list into a table?

0 Answers  

What are few of the schema objects that are created using PL/SQL?

0 Answers  

What is a mutating table

5 Answers   TCS, Tech Mahindra,

Explain alias in sql?

0 Answers  

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

How many sql are there?

0 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers