DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: statement

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    44

    statement

    which stmt would be used ::
    - to add a row in a view ?

    b
    thanks a lot

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2002
    Posts
    44
    can we perform DML operations on a view ?
    thanks a lot

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    you can insert into some views without any problems.

    For complex views you can define an instead-of trigger to handle inserts.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Jan 2002
    Posts
    44
    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

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    insert. same as a table.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Jan 2002
    Posts
    44
    Thanx ....

    i was doing 'Alter view add .............';
    thanks a lot

  9. #9
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- 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
  •  


Click Here to Expand Forum to Full Width