Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2003

    Lightbulb Unanswered: Getting Synonym's Column Length


    Following is an Oracle Issue:

    How Can I Get a Synonym's Column Data Type and Length? when the Synonym is more than one Level, For Example:

    Schema #1: Has a table myTable
    Schema #2: Has a Synonym mySynonym1 to myTable
    Schema #3: Has a Synonym mySynonym2 to mySynonym1

    When the Connection is Done via Schema #3, How one of the Synonym's Column Type and Length would be retrieved by an SQL Statement?

    Thanks in Advance.
    Last edited by saleemb; 07-09-03 at 05:49.

Posting Permissions

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