Oracle updating through a view

Views that access multiple tables can only modify one of the tables in the view.

Views that use functions, specify DISTINCT, or utilize the GROUP BY clause may not be updated.

I tried looking at the profile password settings, but noth...

Do note I am a novice (about 8 months exposure to Oracle Sql - so be gentle please :)I have the following scenario Table A containing: Wave_No, Wave_Desc, Wave_Date Table B containing: Wave_No, Order_No, Order_Date, Order_Status Table C containing: Order_No, Line_No...

The view is, in essence, a stored SELECT statement that masquerades as a table.

Once obtained, can i force oracle to use a particular sql id which was performing better ? Hi, I would like to fing whats the best way to allow user to truncate table that is own by some one else thru forms on-line basis.You can use DML operations on a view if the view does not include Group by, Start with, Connect by, Distinct clauses or any subqueries and set operations(Union, union all, intersect and minus). Whatever DML operations you performed on a view they actually affect the base table of the view. You can Query, Insert, Update and delete from views, just as any other table.I know that one way this can be achived is by granting drop any table system previledge. Hello, I need help in developing a simple interactive page where people across my team can use it to insert/update and select data from an Oracle table. What tools and technologies should I use and how to use them? Hi, Can I, as DBA, force users to change their password on first use...In other words, I want to assign a temporary password when I create the user and force the user to change it on their first login...

Leave a Reply