irish women dating - Oracle updating through a view

The view will become invalid whenever the base table is altered.

oracle updating through a view-32

If I update the view, will the data in the original table get updated?

When modifying data through a view (that is, using INSERT or UPDATE statements) certain limitations exist depending upon the type of view.

The following sections explain how to create, replace, and drop views using SQL commands. To see the empno, ename, sal, deptno, department name and location we have to give a join query like this.

select e.empno,e.ename,e.sal,e.deptno,d.dname,From emp e, dept d where e.deptno=d.deptno; So everytime we want to see emp details and department names where they are working we have to give a long join query.

Hi Tom, Great to visit ask tom site i'm keep on learning oracle things here. i have loaded with "SRC_key = 16" new source data into tables which we used in this view. Short question: If I delete cca 3M entries from table of cca 6.5 rows (and 19 columns), would it be beneficial to re-index? Hello, I want to use TDE tablespace encryption on my database.

One part of my study is "how can I manage my Master key" : my security officer ask me to change regularly the key.

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...

Hypothetically I have two tables Employee and Locations.

Additionaly I have a view view Emp Location which is made by joining Employee and Locations.

If the view exists it will be replaced with the new definition or a new view will be created.

Tags: , ,