facebook

View Oracle XMLTYPE in DB Explorer

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #257378 Reply

    cfhart
    Member

    Is there any chance of adding support for viewing the contents of Oracle XMLType data in the DB Explorer.

    — Fred Hart

    #257443 Reply

    Haris Peco
    Member

    Fred,

    There isn’t special support for XMLType for now, but you can see content of your XMLType with

    SELECT <YOUR_TABLE>.<YOUR_XMLTYPE_COLUMN>.getStringVal()
    FROM <YOUR_TABLE>

    in sql editor

    Best
    Peco

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: View Oracle XMLTYPE in DB Explorer

You must be logged in to post in the forum log in