Updating table through view in oracle updating home wiring

by  |  19-Oct-2016 00:49

select * from emp_det; This will show same result as you have type the long join query.

Now you can treat this EMP_DET view same as any other table.

If you recreate the table (the table that you had dropped), the Oracle VIEW will again be fine.

updating table through view in oracle-17

The user in question must have been granted UPDATE VIEW privs.

A simple view with columns removed should definitely be updatable proividing you have privs to update the view in question...

Selector .selector_input_interaction .selector_input. Selector .selector_input_interaction .selector_spinner.

CREATE VIEW sup_orders AS SELECT suppliers.supplier_id, orders.quantity, orders.price FROM suppliers INNER JOIN orders ON suppliers.supplier_id = orders.supplier_id WHERE suppliers.supplier_name = 'Microsoft'; CREATE or REPLACE VIEW sup_orders AS SELECT suppliers.supplier_id, orders.quantity, orders.price FROM suppliers INNER JOIN orders ON suppliers.supplier_id = orders.supplier_id WHERE suppliers.supplier_name = 'Apple'; A VIEW in Oracle is created by joining one or more tables.

For example, suppose all the employee working in Department No.

Community Discussion