Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Arrow Unanswered: column value

    HOw do i get the default value on all tables (using Oracle 9i)

    so that i know column name, table name and default value ??
    Last edited by sjumma; 01-15-05 at 12:55.
    bigfoots

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Check out the DATA_DEFAULT column, in the USER_TAB_COLUMNS view.

  3. #3
    Join Date
    May 2004
    Location
    Germany
    Posts
    25
    select table_name, column_name, data_default
    from dba_tab_cols
    order by table_name, column_id

Posting Permissions

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