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

Thread: two questions

  1. #1
    Join Date
    Mar 2001

    How many codd's rules are supported by oracle ?
    What are the oops concepts supported by oracle ?

    Thanks in advance.



  2. #2
    Join Date
    Jan 2001

    hey are u a relational purists ? anyway oracle supports approximately 9.5 of codds 12 rules........you can read a book called oracle8/8i special edition by que for an explanation

    for second question i am not sure about the answer......

  3. #3
    Join Date
    Apr 2001

    In OOPS we mainly concentrate on Objects.
    Every object has got two things: Member Data
    And Member Methods.
    OOPS concept revolves around mainly on 4 things those are Abstraction, Encapsulation, Inheritance & Polymorphism
    In Oracle:
    An object type is a user-defined composite datatype that encapsulates a data structure along with the functions and procedures needed to manipulate the data. The variables that form the data structure are called attributes (MEMBER DATA). The functions and procedures that characterize the behavior of the object type are called methods (MEMBER METHODS).
    We usually think of an object (such as a person, car, or bank account) as having attributes and behaviors. For example, a baby has the attributes gender, age, and weight, and the behaviors eat, drink, and sleep. Object types let you maintain this perspective when you sit down to write an application.
    Object types reduce complexity by breaking down a large system into logical entities. This allows you to create software components that are modular, maintainable, and REUSABLE. It also allows different teams of programmers to develop software components concurrently.
    By ENCAPSULATING operations with data, object types let you move data-maintenance code out of SQL scripts and PL/SQL blocks into methods. Object types minimize side effects by allowing access to data only through approved operations. Also, object types hide implementation details, so that you can change the details without affecting client programs.
    Object types allow for realistic data modeling. Complex real-world entities and relationships map directly into object types. Moreover, object types map directly into classes defined in object-oriented languages such as Java and C++. Now your programs can better reflect the world they are trying to simulate.
    More detail u can get in Oracle docs. I have just taken out few theoretical parts to explain basic oops concept in Oracle..

    Hope it will help u ..

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.