Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CLOBs and UNION in db views 1

Status
Not open for further replies.
JenL

JenL

Programmer
Nov 20, 2001
5
CA
Is it possible to use a UNION in an Oracle views when the queries being joined contain CLOB fields?

Thanks!!!!!
 
Sort by date Sort by votes
Have figured out that I can use UNION ALL... thanks anyway
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
937
Rasheed Shaik
Rasheed Shaik
hmckillop
  • Locked
  • Question
Exporting specific data from DB into another DB
Replies
1
Views
152
Beilstwh
Beilstwh
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
634
carp
carp
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
689
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
282
carp
carp

Part and Inventory Search

Sponsor

Back
Top