Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: Data Dictionary table

    Hi all,

    I am using Oracle as back-end and some Business Intelligence tool is being used as front-end. In the business intelligence tool, I need to add the numeric value of the data-types like numeric value of varchar2. So, I was looking in the data dictionary of Oracle to find a table where I can find these number,but coludn't find till now. In MS SQL Server, we have similar table(i.e. systypes) which has the contents I am looking for in Oracle.

    Kindly suggest what can be the tables that I can look into.

    Thanks to all of you in advance.

    Monica.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As far as I know, there's no such table in Oracle database. If you're willing to spend some time reading, here is the Overview of Oracle datatypes.

  3. #3
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Are you looking for ALL_TAB_COLUMNS?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I understood that Monica is looking for a table which contains all datatypes available in Oracle. For example:

    SELECT datatype FROM oracle_datatypes;

    VARCHAR2
    CHAR
    NUMBER
    DATE
    etc.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    select type_name,type_oid from dba_types;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Now, that's something new for me! I didn't know there are 1670 (!?!) type_names in Oracle (10g rel. 2). I recognize only a few of them, while the rest is completely unknown. I wonder what they are used for ... Terra incognita in its full meaning.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Oracle allows the users to specify their own datatypes, and a lot of them have been created for the oracle tools. However, the common types can be displayed with the following query.


    select type_name,type_oid from all_types
    where type_oid < '0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'
    order by type_oid;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •