Results 1 to 6 of 6

Thread: composite data type

  1. #1
    Junior Member
    Join Date
    Apr 2007
    Answers
    11

    Smile composite data type

    dear friends,

    i want to know the details composite data type .

    what is composite data type ?
    how many types of composite data types is there ?.
    and where it is required ?

    plz if u can then with examples ..


    thaks and regrds ...

    from
    sam


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: composite data type

    In oracle
    COMPOSITE DATA TYPES ARE---

    1.RECORD TYPE
    2.NESTED TABLE
    3.VARRYING ARRAY


  3. #3
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: composite data type

    Composite data types are exactly like "Struct" data type in C. You can group logically related different data variable together...


  4. #4

    Re: composite data type

    collections are called as composite datatypes like varray,record,nested tables.
    examples u can write on ur own by using all the above.
    syntax :
    type typename is record(.....)
    type typename is table of(..) index by binary_integer


  5. #5
    Junior Member
    Join Date
    Jun 2007
    Answers
    18

    Thumbs up Re: composite data type

    There are 2 types mainly used
    RECORD TYPE:-stores single row
    INDEX BY:-can hav multiple rows and column
    We use it to handle more than one values at a time
    THESE ARE USED MAINLY IN PL/SQL


  6. #6
    Junior Member
    Join Date
    Feb 2007
    Answers
    17

    Re: composite data type

    Hi,
    in pl/sql we have two types of datatypes
    1. scalar
    2. composite.

    In scalar u can store only one value at a time and
    ex is a number(10),name char(1) etc.

    WHile in Composite u can store whole row mean if one row have 3 columns so u can store 3 values in a composite datatype variable at a time.
    Ex. emp employees%rowtype ;
    Mean if enployees have 3 columns so in variable emp u can store 3 values of 3 columns at a time .
    Hope u Got .
    Bye.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact