ananth890 Posted February 9, 2016 Share Posted February 9, 2016 HI Gurus,i am creating Domain using SQL (Derived tables) . i haveRTRIM(XMLAGG(XMLELEMENT(E,ven.consolidated_vendor_nbr,',').EXTRACT('//text()')).GetClobVal(),',') as vendor_numbers in select statement. after creating table i could not see Vendor number column ( I think Because i am using XML Type) . in TABLE but I can see all other columns except this columns. How can I solve this issue. Thanks in advance for your support. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now