Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 52829 Views
- I also Faced
- E-Mail Answers
Answer Posted / subbu
A Simple view selects from one table. A Complex view
selects from one or more tables.
A Simple view does not contain functions but Complex views
contain functions.
You can perform DML through Simple views but you cannot
always perform DML through Complex views.
| Is This Answer Correct ? | 38 Yes | 6 No |
Post New Answer View All Answers
How to work with data objects interactively?
How to use regular expression in pattern match conditions in oracle?
Can multiple cursors being opened at the same time?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is a tns file?
Why do we use coalesce function in oracle?
What exactly do quotation marks around the table name do?
How to pass a parameter to a cursor in oracle?
Give syntax for SQL and ORACLE joins.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How does one get the view definition of fixed views/tables?
What is bulk collect in oracle?
How to find out what oracle odbc drivers are installed?
