-
statement
which stmt would be used ::
- to add a row in a view ?
b
thanks a lot
-
What?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
can we perform DML operations on a view ?
thanks a lot
-
you can insert into some views without any problems.
For complex views you can define an instead-of trigger to handle inserts.
-
A view is nothing but a virtual table. Can be a join between several tables, masking the base tables, putting security on it are some of th major factors.
Creating a view like this...
Code:
sys@NICK920.US.ORACLE.COM> create or replace view
2 emp_dept
3 as
4 select e.col1,e.col2,e.col3, d.col1,d.col2,d.col3
5 from emp e, dept d
6 where e.deptno = d.deptid
7 /
and then DML it...
Cheers...
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
yeah, thanku !!
could u guys please tell me....
- how to add a row in a view , i mean which query would do it.
thanks a lot
-
-
Thanx ....
i was doing 'Alter view add .............';
thanks a lot
-
doing alter view you change the definition of a view.
I think you'd want to read concepts manual. That will help you understand the use of views(and lot many things...)
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|