what is a view?

Answer Posted / rad

view is a stored query and does not store any table data.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of tables, private synonyms and public synonyms in Oracle?

580


How to convert a date to char in oracle? Give one example.

580


Explain the characteristics of oracle dba?

628


How to end the current transaction in oracle?

541


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1791






How would you best determine why your MVIEW couldnt FAST REFRESH?

1426


is there a tool to trace queries, like profiler for sql server?

584


What is a subquery in oracle?

572


What is an index associated with a constraint?

541


What does sharding mean?

529


What is the difference between truncate & delete command?

607


What do you mean by a tablespace?

556


Explain drop constraint oracle?

585


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1172


What to do if the binary spfile is wrong for the default instance?

553