 Related Questions Latest Answer : 5. The query of the view shoud not consist of any aggregate funtion 6. The query shoud not consist of any subquery 7 And the other option is we can use the instead of trigger to update the Table/s based up on the dml operation issued over the ... Sub query is a query whose return values are used in filtering conditions of the main query. Latest Answer : Hi Guys,A subquery is a SELECT statement that is embedded in a clause of another SQL statement, Called the parent statement.The subquery (inner query) returns a value that is used by the parent statement. Using a nested subquery is equivalent to performing ... A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible. Latest Answer : Take an example Table : Employee(id number primary key,name varchar2(20),departmentid number)If created view in such a fashion, it includes all Not Null attribues & it does not contains group by and disctinct key word, then view is updatableUpdatab;e/insertable ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
