Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    3

    Unanswered: Find the datatype of a column

    Hi,

    How to get the datatype of a column?

    Need to perform activity based on the datatype of a column :

    For eg: if(datatype = datetime)
    {

    }

    Kindly let me know soon!

    Thanks

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Hi,
    information about table columns (with their data types) for current user is present in system view USER_TAB_COLUMNS. System view DBA_TAB_COLUMNS contains info about all columns in the entire database.
    If you want to know more, have a look into Reference book, available with Oracle documentation e.g. online on http://tahiti.oracle.com/

Posting Permissions

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