Reallifecam lina and matk - Oracle updating a view

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.

oracle updating a view-31

who is braylon edwards dating - Oracle updating a view

But it’s still quite common for development work to take place in an environment that is a little lax about this rule, with developers connecting as the data owner to write code.

This could leave you with code that seemed to work in the development environment but suddenly needs a change which grants excess privileges to the end-user before it runs in the production environment.

Insert, Update and Delete SQL Views You can use the "OR Replace" option.

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

We can recompile a view using the Alter view statement, but oracle automatically recompiles the view once it is accessed.

On recompiling the dependent objects become invalid.

Views are very powerful and handy since they can be treated just like any other table but do not occupy the space of a table.

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.

' ); end if; end; select * from emp where ename = 'C Farmer'; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- 3456 C Farmer DBA 7839 01-JUL-02 4000 4 40 1 row selected.

Comments are closed.