Answer Posted / sunitha
View is a logical representation of subset of data.
there are simple,complex and materialized views.
View does't take any space in database.
view are used for security purpose.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is data stored on a disk?
what are the features and advantages of object-oriented programming? : Sql dba
What are the disadvantages of not performing database normalization?
What is sql*plus?
What is rownum and rowid?
how to use in conditions? : Sql dba
What is a trigger word?
What version is sql?
How do I run a query in pl sql developer?
What jobs use sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How do I save a sql query?
How does an execution block start and end in pl sql?
what is an alias command? : Sql dba
Does pl sql work in mysql?