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

Thread: Object????

  1. #1
    Join Date
    Feb 2002
    Posts
    4

    Thumbs up

    I have created an object(user defined datatype)

    CREATE TYPE typ1... OBJECT(a number(4),b varchar2(20));

    Then created one table

    CREATE TABLE tab1(n number(4),ut typ1);

    Then
    SQL>DESC tab1;
    n number
    ut typ1

    In server it is diplaying like above.
    If i run the same in client it is showing...
    n number
    ut UNDEFINED

    Why?

    It is showing typ1 in datadictionary

    What is happening??
    M.Rajani Krishna

    Software Developer

    Vignan's Engineering College

    Vijayawada - 520012

    A.P - India

  2. #2
    Join Date
    Feb 2002
    Location
    http://db-migration.co.in
    Posts
    50
    Hi,
    It depends on the version of the SQL installed at your Client Machine. click Help>About and check the version.
    In version 8 or above, it will display
    SQL> DESC tab1
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    N NUMBER(4)
    UT TYP1
    (it is for Ver. 8.1.6.0.)

    Prakash

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